Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
HassanAshas
Helper V
Helper V

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, 

 

HassanAshas_0-1682289852831.png

 

 

I have a Drop down slicer in my Report which currently looks like this, 

 

HassanAshas_1-1682289902903.png

 

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

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @HassanAshas 

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 names

Ritaf1983_0-1682307020301.png

2. Just choose the slicer that seems to you most usable:
a. Regular slicer with hyierarchy :

Ritaf1983_1-1682307140906.png

b. you can download hierarchial slicer from  market place:

Ritaf1983_2-1682307339245.pngRitaf1983_3-1682307393931.pngRitaf1983_4-1682307440608.png

c. Just use 2 slicers with interaction :
1 for Charachter and secind for name:

Ritaf1983_5-1682307532335.png

Sample file is here 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 



Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

3 REPLIES 3
Ritaf1983
Super User
Super User

Hi @HassanAshas 

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 names

Ritaf1983_0-1682307020301.png

2. Just choose the slicer that seems to you most usable:
a. Regular slicer with hyierarchy :

Ritaf1983_1-1682307140906.png

b. you can download hierarchial slicer from  market place:

Ritaf1983_2-1682307339245.pngRitaf1983_3-1682307393931.pngRitaf1983_4-1682307440608.png

c. Just use 2 slicers with interaction :
1 for Charachter and secind for name:

Ritaf1983_5-1682307532335.png

Sample file is here 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 



Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

This was quite helpful! Thank you so much! 

I was glad to help 🙂

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors