Visual level filtering for slicers

[andrecavaca]

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.

Why Is it not possible to add a Visual level filter for a slicer when this is an option for other chart types?

I'm currently using a 100% stacked column chart as a workaround.

Thanks,

Andre

[Seth_C_Bauer]

@shds @Sreekanth @Anonymous @Anonymous A couple ideas here. One, go vote for this feature on one of these "Ideas"

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

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15091614-can-no-longer-filter-a-slicer

And in the meantime there is a great blog by Reza Rad here that gives you the alternative means to get filtered slicers. It's just a much longer road than click format, set filter 🙂

[Sean]

This is "kind of" related to these Slicer Ideas too

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17267612-slider-slicer-for-values

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17620606-numeric-slider

In Oct 2016 we got the Date Slider in a Slicer containing a Date

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-feature-summary/preview/#dateSlice...

In PowerView in Excel that Slider exists even for Numbers and numeric Measures

That Slider will in effect act as a Filter - between, less than, more than - for Numbers/Amounts (not just dates)

[Seth_C_Bauer]

Thanks for the additional info @Sean. My use case that I have, and was thinking of, was just removing certian values from the dropdown. We used to be able to do this by starting as a table visual, adding filters, then changing it to a slicer. It was a hack, but it worked for one-off, and not relevant values for a particular slicer.

[Sean]

Yes I remeber we used that hack for the "non-existent" Blank in a Slicer

I agree we shouldn't have to go thru that many steps to filter certain values.

The Slider as we've seen in a Date Slicer works great - it would be the same with numbers/amounts!

However I understand if the values are not numeric or dates

you have no use for this Slider option and I agree they should let us use the Visual Level Filters.

I really hope they implement both!

Plus ALL other Ideas that have thousands of votes and we've waited patiently for...

[tlovemark]

Bumping this thread with support for the need to apply visual-level filters to slicers.  The lack of this feature costs our office extra time each day we have to create an overly complicated work-around to achieve this fairly simple objective.

This is a pretty big must-have for our organization. Have several visuals where we only want to expose a small portion of the values to a given audience, the inability to simply add a visual-level filter to the Slicer visual is severely decreasing our efficiency when creating these reports. This seems like it should be a simple option, but instead our report engineers are stuck resorting to work-arounds that rarely justify their effort required.

Please support this feature, cannot overstate how much time this simple fix would save our office.

[jwjwjwjwjw]

I can't believe this feature doesn't exist, makes even the most simple of dashboards more difficult to navigate. This really needs to happen ASAP

[kmccormick]

There is a cusom visualization called "Hierarchy Slicer" that has this functionality. You don't have to use the hierarchy aspect of the slicer if you don't need it, but the list filters down based on your other selections. This needs a permanent fix though, and I know there can be issues with custom visuals on mobile devices. 

https://app.powerbi.com/visuals/show/HierarchySlicer1458836712039

[Petra_Rosenboom]

@kmccormick I tried to use a filter in the Hierarchy slicer, but for that's not possible. Did you really add a filter to that visual (the hierarchy slicer)?

[Anonymous]

Any solutions to this? Am bumping up to this as an issue now...

[Seth_C_Bauer]

@Anonymous I haven't heard of any on the visual end. You would have to deal with it in your model layer.

[austinsense · Accepted solution]

There is a hack for this ...

1. turn the visual into a bar chart

2. apply the visual level filter

3. turn the visual back into a slicer

[Sue]

This did not work for our report

[Anonymous]

I tried this and it did not work, is there any other solution to this question? 

Thank you in advance

[wgjunsay]

Correct me if I'm wrong but I believe this no longer works in the latest version of Power BI.

[biki]

me too have the same problem.

solved temporarily with created double slicer (one on the top of the other)

but sometimes this slicer doesn't work (there's blank option in the slicer)

so i have to re-publish from desktop version to eliminate the blank

and it happens quite frequent

so please, Microsoft, would you fix this?

[Anonymous]

this needs  fix - so annoying that basic capability does not even work, think I need to go back to Tableau....

[biki]

i absolutely agree, please Microsoft, fix this asap.

[grimleyed]

This didn't work for me.  I wish that it did.  I am going to have to filter in the Cube.

[shds]

This workaround no longer seems to be working. No official method available yet either. 

😞

[Seth_C_Bauer]

@shds Correct, broken - no "fix" You would have to handle a "one-off" in your model if this was a unique slicer just for a page. You could do this using a calculated column to define your groups, or a seperate table. (just a couple examples, but both of them are a bit of excessive work for what should be a simple switch)

[Sreekanth]

Even I have the same issue and could not use page filter as that limiting other numbers.