CODEWITHSUNDEEP
powerbi
SSingh
SSingh

Reputation: 153

How To Filter Data in Slicer in Power BI

I am new to Power BI and I have a visual (the slicer) that I want only to be displayed to users of a certain level.

The visual is a list of names but I want the visual to be available only to users of a certain level.

The column that contains these values is available to me through the data model but I can't drag it to the visual level filter because that feature doesn't exist in Power BI.

I can't apply a page level filter because that would restrict other data on the page that they should see.

Is there a workaround I can employ? Ideally I wouldn't want to change the data model.

Upvotes: 3

Views: 2622

Answers (1)

Mike Honey
Mike Honey

Reputation: 15027

My workaround is to hide another Slicer (the "pre-Slicer") behind the real Slicer. The real Slicer needs to have a non-transparent Background set. I mess with Interactions so the "pre-Slicer" only affects the real Slicer, and not all the other visuals on the page.

This is a really annoying limitation that will hopefully be lifted in a future release. Please vote:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12545673-visual-level-filtering-in-slicers

Upvotes: 2

Related Questions