Slicer Single Selection Issue

[mrbuttons]

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!

[miTutorials · Accepted solution]

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]