cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

Have user select only only one slicer or filter

Hi

 

We  have a legacy report which we are now doing in Power BI

The old report had these options ..only one could be chosen.

 

New Items in last month

Closeds Items in last month

New and Closed in last month

Open Items

 

The problem is that Open items overlaps the set of the others . I could have a separate slicer for Open Items

but ideally I want the user to pick one only of the above 4. If I  have a separate open items slicer , and you select open items and then you check separtate slicer Closed items in the last month you will get a list of open items.  This will be confusing to the user. I just want to display this list and they select one filter (radio buttons). I could put the open items on another page but I would have to copy all the visuals there.

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver I
Resolver I

Re: Have user select only only one slicer or filter

Yes I agree there is no way to reset other filters .

 

 

One crude hack is create  one query for each filter scenario in the query designer , Make sure each query has a extra column called 'filter name.' with a value 'scenario x'.  Then union/append these data sets together. Then in the visual, create a slicer based on the  on the 'filter name' column. This way you dupicate  the data many times  - great ;).  But  there  would only be one filter! A sledge hammer to crack a nut.  Maybe  there is a way to pas a parameter to the query not sure ...would be another way..

 

This is what I settled on, create calculated field display in red eg WARNING  if they select more thean one. Dosen't stop them but works well.

 

Report Selected = if ( ISFILTERED('Incidents & SRs All'[Closed Items in the Last Month]) +
 ISFILTERED('Incidents & SRs All'[New in Last Month]) +
 ISFILTERED('Incidents & SRs All'[New and Closed in the last month]) +
 ISFILTERED('Incidents & SRs All'[Open Items]) > 1 ,  "WARNING more than one selected (have field in red)"  , "")

View solution in original post

4 REPLIES 4
Highlighted
Super User IX
Super User IX

Re: Have user select only only one slicer or filter

Can you provide sample data so we can mock this up?


---------------------------------------

Not link spamming! If I posted a link in reply it is because I did assume you know how to search the web but thought it was the fastest way to fix your issue.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Resolver I
Resolver I

Re: Have user select only only one slicer or filter

Sample data

 

id         status        created                    last updated

1          open          LAST MONTH         whatever

2          open          whatever                 whatever

3          closed         LAST MONTH         LAST MONTH

4          closed          whatever               LAST MONTH

 

 

New Items in last month  records  1

Closeds Items in last month  records 3, 4

New and Closed in last month record 3

Open Items  records 1,2

 

Thats the data sample- hope that helps..I want the user to select one of the filter options only (, mutex).  Date Created and last updated are dates in the real world).

 

I can filter each of these scenarios.. but the way i understand slicers work you could pick 'Open Items' slicer and 'Closed item in the last month,' slicer at the same time  - the open items filter would exclude closed items. which is confusing to the user.

Highlighted
Microsoft
Microsoft

Re: Have user select only only one slicer or filter

@ozmike

 

Hi,

 

In the current Power BI version, this is almost impossible if you mean the slicer will be cleared when another slicer is chosen. I have tried the custom visual. But it failed. Maybe you can submit an idea here: https://ideas.powerbi.com/forums/265200-power-bi-ideas?query=slicer

 

 

Best Regards!

Dale

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

Re: Have user select only only one slicer or filter

Yes I agree there is no way to reset other filters .

 

 

One crude hack is create  one query for each filter scenario in the query designer , Make sure each query has a extra column called 'filter name.' with a value 'scenario x'.  Then union/append these data sets together. Then in the visual, create a slicer based on the  on the 'filter name' column. This way you dupicate  the data many times  - great ;).  But  there  would only be one filter! A sledge hammer to crack a nut.  Maybe  there is a way to pas a parameter to the query not sure ...would be another way..

 

This is what I settled on, create calculated field display in red eg WARNING  if they select more thean one. Dosen't stop them but works well.

 

Report Selected = if ( ISFILTERED('Incidents & SRs All'[Closed Items in the Last Month]) +
 ISFILTERED('Incidents & SRs All'[New in Last Month]) +
 ISFILTERED('Incidents & SRs All'[New and Closed in the last month]) +
 ISFILTERED('Incidents & SRs All'[Open Items]) > 1 ,  "WARNING more than one selected (have field in red)"  , "")

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors