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.

timg's avatar
timg
Icon for Solution Sage rankSolution Sage
5 years ago

Hi,

have you checked if the visual is sorted by the order status > ascending ? Perhaps it is currently still sorted by a different column/measure instead.

Best regards,

Tim

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Tim!

The visual was still showing the data in alpha Status order. So starting rethinking the whole process and went to add more data through the power app. Did a refresh to the Power BI report and now the Status shows in the correct order.

Thank you for your response as it helped me rethink it through. Have a great day!