Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sort Visual in Status Order - not alphabetical order

Hi!   Have a Details file with a field called 'Status'. Manually added a new table called Status_Table (see below) that has 'Status' and 'StatusSort'. StatusSort is format whole number:   Sta...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    You could apply the [StatusSort] to Tooltip pane and sort by it like this:

    Here is the pbix file.

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Phil,

Yes I was using the Status from the StatusTable so that is why it was so confusing. I thought of adding more data to the list so used the developed Power App to add more data. Came back to the Power BI dashboard and hit 'Refresh' and now the Status sorts correctly. Thank you for diagrams as that helped to confirm it is accurate. Have a great day!