Hide Chiclet slicer images based on row level security

[electrobrit]

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?

[v-cherch-msft]

Hi @electrobrit 

Please check if below post could help.

https://community.powerbi.com/t5/Desktop/Hide-a-chiclet-slicer-button/td-p/703611

Regards,

[electrobrit]

@v-cherch-msft thank you but there was no solution given in that post or in the example pbix

[electrobrit · Accepted 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.

• Inplace means it will turn grey the values that have no correlation
• Hide means it will remove values with no correlation
• Bottom means is will just re-sort values with no correlation.