cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
everlena
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
v-xicai
Community Support
Community Support

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

3 REPLIES 3
Anonymous
Not applicable

I've been trying to do something similar, and found no good solution, so I created an idea suggestion so maybe we can have this in the future, take a look and vote for it:
Hide/show visuals with measures - Microsoft Power BI Community

v-xicai
Community Support
Community Support

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.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors