Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
DJSwezey
Helper I
Helper I

Published APP: Allow users to re-order rows

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?

DJSwezey_0-1709736459427.png

 

1 ACCEPTED SOLUTION
RossEdwards
Solution Specialist
Solution Specialist

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.

View solution in original post

2 REPLIES 2
DJSwezey
Helper I
Helper I

This is actually even better than what I was looking for. Thank you very much!!

RossEdwards
Solution Specialist
Solution Specialist

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors