Forum Discussion
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. ...
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