Hi All,
Please see below Graph and the order of Result. I need to change the order the result is showing so instead of A,B,WA,WT,WW i would like to see it in the order of A,B,WT,WW,WA. Any help is appreciated.
You need another column that matches up the sort order that you want, so something like:
A,1
B,2
WT,3
WW,4
WA,5
The you can set the "Sort By" column to this other column. You could create this other column in Power Query with an IF statement and then use it as your Sort By column.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
You need another column that matches up the sort order that you want, so something like:
A,1
B,2
WT,3
WW,4
WA,5
The you can set the "Sort By" column to this other column. You could create this other column in Power Query with an IF statement and then use it as your Sort By column.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
We want your feedback!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
