Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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 ...
Need Help
Show and Tell
  • miTutorials's avatar
    miTutorials
    1 year ago

    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]

     

     

miTutorials's avatar
miTutorials
Icon for Super User rankSuper User
1 year ago

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]