cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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!




View solution in original post

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

View solution in original post

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!




View solution in original post

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

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 274 members 3,112 guests
Please welcome our newest community members: