cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
soldstatic Member
Member

Predefined Filter Sets

I'm looking for a way to define a couple different filters and allow the user to 'flip' between these sets quickly. For instance the data set looks like this:

 

ID: (unique ID)

Metric: (metric we are evaluating)

Cause: (~30 defined values)

Failed Component: (~20 defined values)

 

So the dashboard would, by default, show all the visualizations with all the data points included. A user could use a drop down or something to change the 'view' to be "Business Case 1". In which case 15 of the causes are filtered out. 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? The only way I can think of to do it would be to add a column called Business Case 1 and have a long formula to go through the 'if this/that' parameters.

1 ACCEPTED SOLUTION

Accepted Solutions
soldstatic Member
Member

Re: 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.

 

https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Predefined Filter Sets

HI @soldstatic,

 

>>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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
soldstatic Member
Member

Re: Predefined Filter Sets

Sure thing. Here is a sample.

ItemCauseComponentMetric
Item 1AAZZ10
Item 2BBYY9
Item 3CCXX8
Item 4DDWW7
Item 5EEVV6
    
    
Business case 1:Exclude EE, exclude YY
Item 1AAZZ10
Item 3CCXX8
Item 4DDWW7
    
  Dashboard highlights metric:25
    
    
Business case 1:Exclude BB, exclude ZZ
Item 3CCXX8
Item 4DDWW7
Item 5EEVV6
    
  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. 

Community Support Team
Community Support Team

Re: Predefined Filter Sets

HI @soldstatic,

 

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'.

 

5.PNG

 

Result:

2.gif

 

Regards,

Xiaoxin Sheng

 

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
soldstatic Member
Member

Re: 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.

 

https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

View solution in original post

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 346 members 3,259 guests
Please welcome our newest community members: