Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
I made the table above (via Enter Data), named ReferenceTable, that connects ReferenceTable[Status] to DataTable[Status]. Want to sort my visual table in order prescribed in the above image.
DataTable
I selected Sort By Column using DataTable[Status]. However, when I looked at visuals the order is unaffected (see image below).
Any ideas?
If you have a dimension table (as you have) for Status, and there is a single one-to-many relationship between the ReferenceTable[Status] and the DataTable[Status], you don't need the DataTable[RankLookup] field.
All you need to do is sort the ReferenceTable[Status] column by the ReferenceTable[Rank] column in the table view. Next create your visual using the ReferenceTable[Status] column and the measure
Proud to be a Super User!
Paul on Linkedin.
@Anonymous , Make sure rank lookup is used as sort column for status and visual is sorted on status
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 22 | |
| 20 | |
| 12 |
| User | Count |
|---|---|
| 69 | |
| 57 | |
| 42 | |
| 40 | |
| 30 |