Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |