Forum Discussion
Provide sections within the Power BI Slicer Dropdown option
Hi, I want to know if it is possible to provide sections within the Power BI Slicer Dropdown.
Just for example, let's say I have a column with multiple Text values. Let's consider the following table containing 1000 unique names,
I have a Drop down slicer in my Report which currently looks like this,
I want to provide sections within my slicer, that is I want a Sub-heading of every Character before the values of that character starts.
So, it would be like,
A
Aarav
Aaron
B
Brian
Brixton
C
Creed
and etc.
These sub-headings will not be clickable (or clickable, it doesn't matter)
Is it possible to do so in Power BI Slicers?
If you would like to download the Sample Power BI File, then you may do so from here: https://drive.google.com/file/d/1knfvdSsPvteAqaid8qkLTUVqw0zbVeO-/view?usp=sharing
Hi Anonymous
The same thing can be found in several variations.
Here are the steps you need to take:
1. Add column which calculates thi first charachter of the names2. Just choose the slicer that seems to you most usable:
a. Regular slicer with hyierarchy :b. you can download hierarchial slicer from market place:
c. Just use 2 slicers with interaction :
1 for Charachter and secind for name:If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- Ritaf1983
Super User
Hi Anonymous
The same thing can be found in several variations.
Here are the steps you need to take:
1. Add column which calculates thi first charachter of the names2. Just choose the slicer that seems to you most usable:
a. Regular slicer with hyierarchy :b. you can download hierarchial slicer from market place:
c. Just use 2 slicers with interaction :
1 for Charachter and secind for name:If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Ritaf1983
I was glad to help 🙂