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 have a bunch of orders, each with a status of Won, Lost or Open. All of these orders are divided by region. So I throw them all up on a Clustered Column chart, sorting by region. Great - all works. Except that for each region, the order of the columns within the region is alpha - Lost, Open, Won. I need it to be Won, Open, Lost.
So I created a new column - Status Order - and populated it with:
Status Order = IF('Order'[Status] = "Won", 1, IF('Order'[Status] = "Open", 2, 3))
and used the Sort by Column item in the Modelling tab to sort by that column rather than by the Status column, which it was sorting by.
It didn't work - made no difference at all to the display.
What am I doing wrong? Or not doing?
Thanks in advance.
try this,
Drag drop the "Status Order" Column into the tooltip section of the chart and sort the chart on this "Status Order"
That loses me the initial sort, by region.
It also puts the Status Order column in the tooltip, where I don't want it.
Hi @Budfudder
How are you sorting this in modelling?
Try this way:
In fields Panel-> go to the table-> select Status column, Now go to Modelling tab-> Sort by Status order column.
Please confirm does it solve the problem.
Thanks
Raj
"
and used the Sort by Column item in the Modelling tab to sort by that column rather than by the Status column, which it was sorting by.
It didn't work - made no difference at all to the display."
- Could you please post the snapshot of how you do this sorting?
Thanks
Raj
See below
Rather than make a new column you could just create a new table saying Won 1, Open 2, Lost 3 and then link it, then try to sort by that column?
I'm not sure how/whether that would work - my data source is actually one very long SQL statement pulling in five or six tables from the database.
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |