Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
211 views
in Technique[技术] by (71.8m points)

powerbi - Slicer is got getting filtered

I have sales table.

I have created slicer on sales region. This shows all sales region options.

Then I added 2 table visual with sales region and sales amount. Anothet table with sales region and count of workers.

Selecting any item from slicer filters both the table. Selecting a region in any table filters the other table.

However, selecting the region in table dows not filter the slicer. Is this by design or can it be controlled so filter passes from table into slicer?

question from:https://stackoverflow.com/questions/65933704/slicer-is-got-getting-filtered

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

You can edit interaction from Format tab in the ribbon. From there you can define the interaction between each visuals.

For more details, you can visit Here

========================

I think I got your concern now. Please check the quoted text I got by googling-

You can filter all visuals in Power BI except Slicer! In fact slicer itself is a type of filter, however there are some times that number of items in slicer is too many. So this is normal that we want to filter the items in the slicer itself. Unfortunately current version of Power BI Desktop doesn’t support visual level filter on slicer.

To me, it's a logical functionality or behavior or interaction between different visual and slicer. Otherwise if slicer got filtered itself by selection values in a table or other visuals, in some case it will produce circular dependency.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...