Forum Discussion
Slicer Single Selection Issue
Hello everyone,
I have a slicer that is a combination of two columns. Slicer is in single selection.
When selecting the etl_update time selection (parent), it automatically selects all the other selection in the hierarchy.
How do I go about to disable any selection in the parent box or any way to not automatically select all boxes under its hierarchy?
Thanks!
What you’re seeing is typical behavior when using a hierarchical slicer in Power BI. When the slicer is in single selection mode and you click a parent item, Power BI will automatically expand it and select all child items under that parent
Instead of using a hierarchy in your slicer, create a calculated column that combines both hierarchy levels into a single string, like:CombinedColumn = Table[ParentColumn] & " - " & Table[ChildColumn]
1 Reply
What you’re seeing is typical behavior when using a hierarchical slicer in Power BI. When the slicer is in single selection mode and you click a parent item, Power BI will automatically expand it and select all child items under that parent
Instead of using a hierarchy in your slicer, create a calculated column that combines both hierarchy levels into a single string, like:CombinedColumn = Table[ParentColumn] & " - " & Table[ChildColumn]