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,
>>However the user switch the drop down to "Business Case 2" in which case only 3 causes are filtered out but 10 failed components are filtered out. In my case I'd specifically like this to basically filter the whole report. Is this possible?
I don't think you can use slicer/filter to filter 'failed component'. Normally, it will only return records which match with 'case 2'.
Can you please share some same data with excepted result? It will be help to clarify your requirement.
Regards,
XIaoxin Sheng
Sure thing. Here is a sample.
| Item | Cause | Component | Metric |
| Item 1 | AA | ZZ | 10 |
| Item 2 | BB | YY | 9 |
| Item 3 | CC | XX | 8 |
| Item 4 | DD | WW | 7 |
| Item 5 | EE | VV | 6 |
| Business case 1: | Exclude EE, exclude YY | ||
| Item 1 | AA | ZZ | 10 |
| Item 3 | CC | XX | 8 |
| Item 4 | DD | WW | 7 |
| Dashboard highlights metric: | 25 | ||
| Business case 1: | Exclude BB, exclude ZZ | ||
| Item 3 | CC | XX | 8 |
| Item 4 | DD | WW | 7 |
| Item 5 | EE | VV | 6 |
| Dashboard highlights metric: | 21 |
So if I want the user to be able to switch between two business cases, (one view is good for one department, the other is good for a different department), currently they would have to clear all the filters and then apply two different filters on cause and component based on which department they are in. The people viewing the dashboard don't know jack about the underlying data though, so this is no good. I need to have them be able to select from "Business Case 1" and "Business Case 2".
For this simplistic data set, creating a 'Business Case' column wouldn't be too difficult, but as I mentioned in the real world scenario there are about 30 different acceptable values for both Cause and Component, and there are actually another 6 fields that make up the filter.
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.