Wael_BenAmar's avatar
Wael_BenAmar
New Member
2 years ago
Status:
New

Slicer - Select leafs only

Hello, Is it possible to add a feature for the slicer when using a hierarchy to be able only to select leafs only for the single selection mode ? Many thanks
power bi
kleigh's avatar
kleigh
Icon for Responsive Resident rankResponsive Resident
2 days ago

For some reason, the new list slicer supports only the weaker "Single Select" with "Restrict to leaf nodes". You can't in the UI pick both "Force Selection" and "Restrict to leaf nodes" at the same time - when both of these options are required to actually have a single select slicer.

  • Without "Restrict to leaf nodes", higher level items are selectable which bypasses single selection.
  • Without "Force selection", nothing can be selected, which selects everything, bypassing single selection.

It's possible to force the slicer to have both options by using a style preset in a custom theme.

"selection": [{     "singleSelect": true,    "strictSingleSelect": true,    "restrictToLeafNodes": true    }]

This seems to work with some limited testing... so it looks like it's just an issue with the UI incorrectly hiding the options?

Recent ideas