Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Cannot sort Table Visual using indexed column and custom sort

DataLedAnalysis_0-1662383610775.png

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.

 

DataTableDataTable

 

I selected Sort By Column using DataTable[Status]. However, when I looked at visuals the order is unaffected (see image below).

 

DataLedAnalysis_2-1662383873831.png

Any ideas?

 

2 REPLIES 2
PaulDBrown
Community Champion
Community Champion

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





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






amitchandak
Super User
Super User

@Anonymous , Make sure rank lookup is used as sort column for status and visual is sorted on status

 

Sort Month Year.png

 

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.