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 nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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!
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 22 | |
| 20 | |
| 14 | |
| 13 | |
| 13 |
| User | Count |
|---|---|
| 62 | |
| 40 | |
| 38 | |
| 38 | |
| 38 |