Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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