Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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!
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.