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

Categories

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

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

1 Answer

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.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
...