Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cannot sort Table Visual using indexed column and custom sort


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.




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



Any ideas?


Super User
Super User

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.

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:

!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors