cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

hide/unhide slicer based on a measure

Hi Guys,
I have just started my first little practise project in Power BI and I came across this problem - 

I need to hide a slicer (slicer_to_hide) based on user selection on other slicer (slicer_selection).
I know how to hide other visuals but with slicer it gets more complicated.
So this is a scenario:

  1.  user selects values on slicer_selection
  2.  when certain values are selected a slicer_to_hide pops up.
  3.  now the user needs to select a value from slider_to_hide  -----> that's why I  can't use transparent card visual as a cover because then user won't be able to select from the slicer
  4. let's say that now a user changes values on slicer_selection in a way that criteria for a pop-up slicer are not met

and this is where problem is. The value that has been selected on the slicer_to_hide stays visible 

 

1.png2.png

 

 

 

 

 


I'll be grateful for any clues cause I have run out of ideas

Thanks,
everlena

PS I'm new here, I'm not sure how it works. I don't know how to post best

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: hide/unhide slicer based on a measure

Hi @everlena ,

 

You create measure to determine if show the message, and display the measure in Card visual over your slicer chart.

 

Measure = IF(ISFILTERED(Table1[Yes/No]),"", "Need to choose a selection")

 

For reference:

 

https://community.powerbi.com/t5/Desktop/Stacked-Column-chart/m-p/648754#M311066

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: hide/unhide slicer based on a measure

Hi @everlena ,

 

You create measure to determine if show the message, and display the measure in Card visual over your slicer chart.

 

Measure = IF(ISFILTERED(Table1[Yes/No]),"", "Need to choose a selection")

 

For reference:

 

https://community.powerbi.com/t5/Desktop/Stacked-Column-chart/m-p/648754#M311066

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Frequent Visitor

Re: hide/unhide slicer based on a measure

Hi @Amy,

 

Sorry for a late reply. If I understood you well this soultion won't work in my case.

Based on a chosen date in one of the slicers I want to hide or display a slicer showing option to choose yes/no. 

If I cover that yes/no slicer with a card visual I wouldn't be able to choose a value from that slicer because card visual will be in front. 
I don't really want to display any message. I want a slicer yes/no to show up when certain dates are chosen and I want it to be invisible in any other case. 

Kind regards,

Ewelina

 

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

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