Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi, I have a dashboard that I have published and added to an app. This will be sent out to some employees as a research tool to dive into problems with particular areas of business. The report is simply a matrix with a handful of values and 6 different rows. I want to know if it is possible to allow users of the app to reorder the rows to their liking? For example, someone might want to see the data rolled up by Station first rather than Advertiser. I want to allow them to slide Station to the top so they can get the appropriate visual for their particular research query. Any idea if this is possible?
Solved! Go to Solution.
The use of Field Paramters is what you are looking for.
Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn
A field parameter table is essentially a list of fields. When you use your field parameter column in a visual, you need a corresponding filter, usually in a slicer, to specify which field its pointing to. So if you have a matrix of 6 rows, you set up 6 field parameter tables and 6 slicers. Users then can choose individually what each of those 6 matrix fields are going to be.
This is actually even better than what I was looking for. Thank you very much!!
The use of Field Paramters is what you are looking for.
Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn
A field parameter table is essentially a list of fields. When you use your field parameter column in a visual, you need a corresponding filter, usually in a slicer, to specify which field its pointing to. So if you have a matrix of 6 rows, you set up 6 field parameter tables and 6 slicers. Users then can choose individually what each of those 6 matrix fields are going to be.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.