Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.