Forum Discussion
Predefined Filter Sets
Actually I apologize but I just found out there is a much easier way to do this. PowerBI has a beta feature that you have to enable, but the 'Bookmarks" feature works almost perfectly. One can set up some shapes to act as buttons on the dashboard so that novice users can get in and just push a button to flip between different scenarios. It's not quite the drop down list that I would prefer, but it will do what I need to do.
HI Anonymous,
So you want to achieve exclude filter, right? If this is a case, current you can't use normal slicer to these effect.
I'd like to suggest you create two slicer table and write a measure to check filter conditions.
Then drag above measure to visual level filter to achieve filter affect.
Sample:
Selector tables.(not have relationship to original table)
Cause Selector = VALUES(Sample[Cause]) Component Selector = VALUES(Sample[Component])
Measure:
Flag =
IF (
SELECTEDVALUE ( Sample[Cause] ) IN ALLSELECTED ( 'Cause Selector'[Cause] )
|| SELECTEDVALUE ( Sample[Component] )
IN ALLSELECTED ( 'Component Selector'[Component] ),
"N",
"Y"
)
Create table visual with original data, then drag above measure to visual level filter to filter if flag measure equal to 'Y'.
Result:
Regards,
Xiaoxin Sheng
Actually I apologize but I just found out there is a much easier way to do this. PowerBI has a beta feature that you have to enable, but the 'Bookmarks" feature works almost perfectly. One can set up some shapes to act as buttons on the dashboard so that novice users can get in and just push a button to flip between different scenarios. It's not quite the drop down list that I would prefer, but it will do what I need to do.