Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I got stuck in my task. I have kept two slicers in my page. First slicer will have two options (product and city) and second slicer will have options for the above slicer(if country selected second slicer lists list of countries). if no option is selected in slicer1, the second slicer is displaying all values for country and products, whereas i want to hide second slicer when no option is selected in slicer1.
Hope for a sooner solution.
Thankyou
Solved! Go to Solution.
Hi @Anonymous ,
You can refer to this blog: Show or Hide a Power BI Visual Based on Selection.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You can refer to this blog: Show or Hide a Power BI Visual Based on Selection.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
If I understand you correctly then one thing you could try would be to create a measure like this
HideSlicer = IF(ISFILTERED(Table[Slicer1Column]),1,0)
Then use the measure as a filter on the second slicer like below
This should "hide" the second slicer when no option is selected in the first
This is hiding the other options in slicer1
Hi @Anonymous ,
Please give me more details such as some screenshots.
Best Regards,
Icey
Thankyou Gordonlilj, but this measure is not helping to hide the slicer. can you pls check in your application
The measure works for its intended use. Can you be more specific?
This is hiding the other options in slicer 1, when i select a option
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |