Skip to main content

Power BI

Completed

Visual level filtering in slicers

Vote (2792) Share
Andre Cavaca's profile image

Andre Cavaca on 02 Mar 2016 03:49:41

I have a large set of options from which I would like to pick some specific ones and use them in a slicer to filter my data.
Currently, this is not possible while it is an implemented feature for other chart types.
I'm currently using a 100% stacked column chart as a workaround.

Administrator on 14 Jun 2019 04:06:20

I'm happy to say this is now complete! In the June 2019 release of Power BI Desktop you'll see you can set visual level filters on slicers. There's one known issue where applying a measure filter to a slicer in range mode causes the visual to show an error. We'll release a fix in an interim update before the July release. Thanks for your patience and your votes, everyone!

Comments (149)
Andre Cavaca's profile image Profile Picture

Robert Wolf on 05 Jul 2020 23:25:19

RE: Visual level filtering in slicers

very needed creates a lot of seemingly unnecessary labor to get around this seemingly simple solution. Though I have a feeling for Microsoft it is harder than it would seem.

Andre Cavaca's profile image Profile Picture

Ramóna Gáspár on 05 Jul 2020 23:24:54

RE: Visual level filtering in slicers

Our slicer is full of unnecessary data without this function, unusable, please do some development!

Andre Cavaca's profile image Profile Picture

Colin Giles on 05 Jul 2020 23:24:36

RE: Visual level filtering in slicers

Seriously needed

Andre Cavaca's profile image Profile Picture

VG on 05 Jul 2020 23:24:21

RE: Visual level filtering in slicers


I support the request. This functionality is very necessary for those of us who migrate our Excel reports to Power BI

Andre Cavaca's profile image Profile Picture

Narayana Power BI User on 05 Jul 2020 23:24:20

RE: Visual level filtering in slicers

To make this feature really powerful, please also add the ability to add a measure as a visual level filter just like can be done for regular visuals and charts.

Andre Cavaca's profile image Profile Picture

vishnu on 05 Jul 2020 23:24:03

RE: Visual level filtering in slicers

Very much needed feature

Andre Cavaca's profile image Profile Picture

Power BI User on 05 Jul 2020 23:23:19

RE: Visual level filtering in slicers

any update.. pls..

Andre Cavaca's profile image Profile Picture

Power BI User on 05 Jul 2020 23:23:19

RE: Visual level filtering in slicers

i think, my company should look towards tableau..

Andre Cavaca's profile image Profile Picture

Power BI User on 05 Jul 2020 23:22:10

RE: Visual level filtering in slicers

Very much needed feature. I am using Direct Query mode and hence cannot make a workaround of calculated Table. Another workaround of hiding a slicer behind another slicer works if u know what values need to be selected. But for me i need TOP 10 values, displayed in Slicer which is dynamic and in direct Query.

It will be good to connect a slicer with a visual and display the values in that visual, an another Idea.

Andre Cavaca's profile image Profile Picture

Marius Sveen on 05 Jul 2020 23:21:29

RE: Visual level filtering in slicers

Hi,
Would be great if we could filter slicers with measures as well.

test = COUNT ( 'test'[test] )

Then put the "test" measure in visual filter and say you only want to show >= 1