Forum Discussion
Swap visuals based on bulk filter button
Hello ALL,
I am learning PowerBI and i am in need of help from experts like you.
I need to keep button like filters. Suppose, button1 consisits of set of versions(i.e versions 0.1, 0.2 , 0.3 ,.. 0.9) buttun2 consistes of another set of versions(i.e versions 1.1, 1.2, 1.3 ,... 1.9).
I want to use these two buttons like filters. If i select button1, visulas will be showing only those values which have versions 0.1 to 0.9 . If i click on button2 in the same visual, it should show the values having versions 1.1 to 1.9
Is this possible? if possible, how can i achieve this.
Please suggest me your ideas
2 Replies
If those values "0.1~0.9" and "1.1~1.9" are filtering same column, it's not possible to split them into two slicers.
In this scenario, you can create a bucket column like:
Bucket =IF(Table[Column]<1,"0.x","1.x")
Then you can put this bucket column into a slicer. When you select a "bucket", the corresponding values will be cascading filtered in another slicer.
Regards,
