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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Re-arranging row and column values

image.png

 

Hi - I'm looking to re-arrange the row and column values in this matrix. I can't drag and drop like in excel and I'm wondering if there's another way to specify the order (maybe by creating an index in query editor?). 

 

Ideally, the rows will look like (<=7, 8-24, 25-30, 30+, NONE) and the columns (0, 0-20, 21-40, 41-60, etc...)

 

Appreciate the assistance!

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

 

Create a two column table with buckets whcih you have dragged to teh row labels appearing in the first column and their order (simple numbers) in the second column.  Take this 2 column table to the Data Model.  Create a relatioship from the buckets appearing in your base data to the first column of this table.  With the help of the RELATED() function, bring over the numbers column from this new table to the base data table.  Then use the Sort by column feature in the base data table.  Remember to drag the bucket from the base data table (not from the new table).

 

Repeat the steps above for the buckets appearing in the column labels as well.

 

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

1 REPLY 1
Ashish_Mathur
Super User
Super User

Hi,

 

Create a two column table with buckets whcih you have dragged to teh row labels appearing in the first column and their order (simple numbers) in the second column.  Take this 2 column table to the Data Model.  Create a relatioship from the buckets appearing in your base data to the first column of this table.  With the help of the RELATED() function, bring over the numbers column from this new table to the base data table.  Then use the Sort by column feature in the base data table.  Remember to drag the bucket from the base data table (not from the new table).

 

Repeat the steps above for the buckets appearing in the column labels as well.

 

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.