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

More than one slicer for the same field?

I would like to put two slicers on the same page (I know, that's easy, but here's the catch): however, I want them to slice the same field.

 

Here's the deal:  I have a field with only 4 elements.  I would like to have one slicer which offers only the first two, and another which shows only the second two.  But I only seem to be able to put the field in either the Page Level Filters or the Report Level Filters.  It ignores me when I try to put it in the Visual Level Filters.

 

Is there a way to do this?

 

Thanks

2 ACCEPTED SOLUTIONS

Accepted Solutions
Vvelarde Super Contributor
Super Contributor

Re: More than one slicer for the same field?

@randymadden

 

Is not exactly like a slicer but can work depends in your scenario.

 

And to show only 2 elements ..in Visual Level Filter select the Elements that you want to show in the visual.

 

In Values put Count (Distinct) to made all the elements with the same size.




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

Proud to be a Datanaut!




Moderator v-caliao-msft
Moderator

Re: More than one slicer for the same field?

@randymadden,

 

1) Can a Treemap be used to replicate the behavior of a slicer?
Can you elaborate your requirement, why do you need use two slicers for the same field? So that we can check if Treemap can be used to replicate the behavior of a slicer.

 

2) How do you configure it to only show 2 of the elements?

Capture.PNG

 

Regards,

Charlie Liao

4 REPLIES 4
Vvelarde Super Contributor
Super Contributor

Re: More than one slicer for the same field?

@randymadden

 

In a Slicer can't  applied a Visual Level filter.

 

My suggestion is use 2 TreeMaps.

 

TreeMap.png

 

 

 




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

Proud to be a Datanaut!




randymadden Frequent Visitor
Frequent Visitor

Re: More than one slicer for the same field?

This seems to be a solution, thank you.  But I have two problems: 1) Can a Treemap be used to replicate the behavior of a slicer?, 2) How do you configure it to only show 2 of the elements?

 

Thanks, Rm

Vvelarde Super Contributor
Super Contributor

Re: More than one slicer for the same field?

@randymadden

 

Is not exactly like a slicer but can work depends in your scenario.

 

And to show only 2 elements ..in Visual Level Filter select the Elements that you want to show in the visual.

 

In Values put Count (Distinct) to made all the elements with the same size.




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

Proud to be a Datanaut!




Moderator v-caliao-msft
Moderator

Re: More than one slicer for the same field?

@randymadden,

 

1) Can a Treemap be used to replicate the behavior of a slicer?
Can you elaborate your requirement, why do you need use two slicers for the same field? So that we can check if Treemap can be used to replicate the behavior of a slicer.

 

2) How do you configure it to only show 2 of the elements?

Capture.PNG

 

Regards,

Charlie Liao

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 145 members 2,344 guests
Please welcome our newest community members: