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.
I have a report where I'm using chiclet slicers for the Regions. If a corporate user, you can select a Region to see how that region is doing as a whole.
In this scenario, Regions contain Stores. So Region A-contains Store 1-10, Region B-Store 11-20, etc.
I have also added row level security so if the user is from Store 2, they'll see their data from Store 2 but I was hoping the chiclets for all other regions would be hidden so all they see is Region A chiclet. Right now, they all show and if you click on another region's chiclet, obviously all visuals go blank. Rather them just be hidden.
Any thoughts on how to hide them?
Solved! Go to Solution.
I did figure this out and it took nothing fancy. All I had to do was change the behavior to HIDE on the General tab.
-this article alerted me to that https://blog.pragmaticworks.com/power-bi-custom-visuals-chiclet-slicer
You may also choose to change how the Chiclet Slicer behaves when there is not correlation between values using the Show Disabled property.
Hi @electrobrit
Please check if below post could help.
https://community.powerbi.com/t5/Desktop/Hide-a-chiclet-slicer-button/td-p/703611
Regards,
@v-cherch-msft thank you but there was no solution given in that post or in the example pbix
I did figure this out and it took nothing fancy. All I had to do was change the behavior to HIDE on the General tab.
-this article alerted me to that https://blog.pragmaticworks.com/power-bi-custom-visuals-chiclet-slicer
You may also choose to change how the Chiclet Slicer behaves when there is not correlation between values using the Show Disabled property.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |