Skip to main content

Power BI

New

Improve display of selected item in Dropdown slicer

Vote (11) Share
Salvatore Cagliari's profile image

Salvatore Cagliari on 30 Jun 2023 07:53:43

Dear team


As of today, when I select an item in a hierarchy with a Dropdown Slicer, we see the selected items from top to down, including the column names.

For example, when we have a product hierarchy (Product Category, Subcategory, and Product Name, and I select Computers - Desktop -> Dell Desktop PC, we get the following list of Items when I close the Dropdown:

Computers (Product Category) + Desktop (Subcategory) + Dell Desktop PC (Product Name)


We need the following possibilities:

  1. The ability to disable the display of the column name (Result: Computers + Desktop + Dell Desktop PC)
  2. The ability to display the selected Item from the bottom up (Result: Dell Desktop PC + Desktop + Computers)
  3. The ability to display only directly selected items in the Hierarchy (Result: Dell Desktop PC)
  4. We should see only that when I select a node in the hierarchy. For example, if I select Audio + Bluetooth headset, I would like to see only Bluetooth headsets


To have this today, I need to program a Title Measure to display what I select.

This shouldn't be necessary.