Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Self teaching Power BI and can't quite seem to get the correct DAX to sort diameter sizing depicted as the column headers here. How can I get the matrix to sort the diameters from smallest to largest? Thanks in advance for your help!
Solved! Go to Solution.
Hi @SRIKER,
Add a conditional column in Query Editor mode.
In data view mode, change the default sort by column to [Sort Order].
Result.
Best regards,
Yuliana Gu
Hi @SRIKER,
Add a conditional column in Query Editor mode.
In data view mode, change the default sort by column to [Sort Order].
Result.
Best regards,
Yuliana Gu
Thank you @v-yulgu-msft. This is exactly what need! Unfortunately my Premium version does not seem to have the Add Column tab no the Conditional Column button. Double checked my version and I'm up to date. Bummer!
Sorry! I'm a rookie over here. Found it!. Thanks again for your help!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 90 | |
| 78 | |
| 66 | |
| 65 |