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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
speedramps
Super User
Super User

Single selection on hierarchy slicer

Dear all

 

Please can you help me …

speedramps_0-1656699730028.png

The standard Power Bi Slicer allows hierarchies and single selection.

But if the user clicks a parent category, then all the child items are selected, thus breaking the single selection rule.

 

I would like to disable the selection at the parent level, to enforce single child selection policy.

But I still want to keep the nice hierarchy layered structure.

Is that possible with standard or custom visuals?

 

See attached example.

Click here to download an example 

 

Single selection is switched on but if you click the large, medium or small category then all items are selected.

I want to keep the large, medium or large hierarchy structure
but prevent the users from selecting the large, medium or small groups.

Forcing the user to just select 1 item and not a whole group.

 

Kudos for anyone with a good answer,

but please don’t respond saying this is not a current standard feature and I can suggest it as a new feature. I kind of know that ! 😀

I want to hear solutions please.   Thank you!

 

Warmest regards

 

 

 

1 ACCEPTED SOLUTION
speedramps
Super User
Super User

I found a solution myself.

If anyone need a solution to the same kind of pronlem then try using the HierarchySlicer custom visual

which allows you to configure selection only a "leaf" level.

Hope Microsof include the "leaf" level option in the standard filter visual.

 

 

View solution in original post

1 REPLY 1
speedramps
Super User
Super User

I found a solution myself.

If anyone need a solution to the same kind of pronlem then try using the HierarchySlicer custom visual

which allows you to configure selection only a "leaf" level.

Hope Microsof include the "leaf" level option in the standard filter visual.

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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