Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
elaj
Helper IV
Helper IV

display same row multiple times in different hierarchies in slicer

Hi,

is it somehow possible to show one element in two different hierarchys in a slicer?

like that?

 

image.png

 

and when i click on var1... either in BM_3 or in no BM set. The other var1 should be marked as selected as well.

 

thanks for help

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

@elaj 

Even if you have var1 under both BM_3 and 'no BM set' selecting one will not select the other.  That breaks the concept of a 'hierarchy'.   

jdbuchanan71_0-1614618068325.png

You could move the field that contains var1, var2, var3 to it's own slicer, then if you select var1 it would be all var1, not just the var1 under the level above it.

View solution in original post

2 REPLIES 2
jdbuchanan71
Super User
Super User

@elaj 

Even if you have var1 under both BM_3 and 'no BM set' selecting one will not select the other.  That breaks the concept of a 'hierarchy'.   

jdbuchanan71_0-1614618068325.png

You could move the field that contains var1, var2, var3 to it's own slicer, then if you select var1 it would be all var1, not just the var1 under the level above it.

vanessafvg
Super User
Super User

well if your data is set to that in the grain ie your data row will look like this

variant bm3 var1 

variant noBM var1 

 

then yes, how does your data look?

 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.