Dynamically hide a slicer if there is only distinct value?

[markazali]

I have a slicer that can contain 1 or more different values. Is it possible to hide the slicer if it is only storing 1 value? I want to use the same PBIX file for multiple clients and this slicer may not be applicable for all.

I am accessing data using a OneLake data hub dataset. I am unable to create roles (Manage Roles is dimmed).

[parry2k]

@markazali Yes the same approach can be deployed on it. why not? End of the day you just need to count how many rows are visible for the slicer and then use conditional formatting to hide/unhide.

[parry2k]

@markazali you can work with conditional formatting but that is a workaround. check videos on my YT channel Color transparency and conditional formatting is VERY powerful Part 1 - Power BI - YouTube

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️

[markazali]

I understand your tutorial as a way to hide a visual unless a slicer is used. I am looking for a way to hide a slicer if there is only 1 value within the slicer.