cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andrecavaca Frequent Visitor
Frequent Visitor

Visual level filtering for slicers

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
austinsense Established Member
Established Member

Re: Visual level filtering for slicers

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

Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast Smiley Happy
54 REPLIES 54
Phil_Seamark Super Contributor
Super Contributor

Re: Visual level filtering for slicers

Add your idea to the ideas section and let us know here so we can vote for it. Smiley Happy


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

andrecavaca Frequent Visitor
Frequent Visitor

Re: Visual level filtering for slicers

Super User
Super User

Re: Visual level filtering for slicers

@andrecavaca - You should definitely post to Ideas, but why not just use Enter Data or another query to create a table with just the values you want, relate the two tables and use the second table as your slicer? Boom!


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


XLBob Regular Visitor
Regular Visitor

Re: Visual level filtering for slicers

I think the query is the better option so you can to some extent keep your filter list dynamic. You can either write a new query or use table measure to do that.
Highlighted
austinsense Established Member
Established Member

Re: Visual level filtering for slicers

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

Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast Smiley Happy
andrecavaca Frequent Visitor
Frequent Visitor

Re: Visual level filtering for slicers

@Greg_Deckler I'm using an Analysis Service connection which doesn't have those modelling capabilities (yet!)

 

@austinsense That's awesome! And works both with the out of the box slicer and the chiclet slicer custom chart! Thank you

Tishchenko Established Member
Established Member

Re: Visual level filtering for slicers

@austinsense, Power BI Desktop June update kill this hack Smiley Sad

karola_shanker Frequent Visitor
Frequent Visitor

Re: Visual level filtering for slicers

After the June release, the problem is back. Any solution for this now?

Super User
Super User

Re: Visual level filtering for slicers

@karola_shanker Can you be more specific? Do none of the "hack" ideas work for you?

Near SE WI? Join our PUG Milwaukee Brew City PUG