Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hello!
I've done some workarounds to arrange the following drop-down slicer menu within in the header of columns in a table-visual.
However, would it maybe be possible to have a better/easier/less time-consuming way to arrange something similar?
Thank you in advance!
Solved! Go to Solution.
Hi,
Unfortunately there is no option to make your headers with a dropdown. Something similar like in Excel would be great to have. 😞
You did it with slicers while it's annoying to make it's probably the best way to do it.
Things you might want to consider (they are very similar just different approaches, so I assume this won't help your case)
- drilldown method as in school --> class --> student
- Use of field parameters slicers this way you can make the table interactive for your users
Hi,
Unfortunately there is no option to make your headers with a dropdown. Something similar like in Excel would be great to have. 😞
You did it with slicers while it's annoying to make it's probably the best way to do it.
Things you might want to consider (they are very similar just different approaches, so I assume this won't help your case)
- drilldown method as in school --> class --> student
- Use of field parameters slicers this way you can make the table interactive for your users
Yea, it already uses field parameters to let the user determine what columns need to be shown. But I will keep it this way then! Thank you!
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 22 | |
| 22 | |
| 21 | |
| 20 | |
| 12 |
| User | Count |
|---|---|
| 58 | |
| 55 | |
| 41 | |
| 36 | |
| 34 |