Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I created a column in Query Editor called 'Order' and i've used an IF statement to define the order as 01, 02, 03 etc. I ensured the column is a Whole Number.
I've then sorted my Row item by the Order column in the Modelling tab, and it's made no difference to the order whatsoever!
Below are some screenshots, have I missed something obvious?
Solved! Go to Solution.
Wow do I feel stoopid. It had not occured to me to check WHAT order it was using. When I did, I realised it WAS using the right order. I must have had my Matrix sorted by something else, when I clicked on my Row Item to sort by that, it works!
Sorry for all the fuss!
I'm missing something, all of your Order's are 1?
That's just a bad preview - if the P&L item is Gross Written Premium (which all of the first rows are) then the order number is 1.
I have checked the full dataset and there are numbers 1-19 in there I promise.
Wow do I feel stoopid. It had not occured to me to check WHAT order it was using. When I did, I realised it WAS using the right order. I must have had my Matrix sorted by something else, when I clicked on my Row Item to sort by that, it works!
Sorry for all the fuss!
OK, so what order are you seeing?
1
11
12
13
14
15
16
17
18
19
2
3
...
Or something else?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |