March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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:
and this is where problem is. The value that has been selected on the slicer_to_hide stays visible
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
Solved! Go to Solution.
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.
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
90 | |
86 | |
76 | |
49 |
User | Count |
---|---|
166 | |
149 | |
99 | |
73 | |
57 |