Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Simple sort issue

For the love of god, I am not able to sort this priority in the visualization. I need the High and Medium in the order of Low, Medium, High, and Critical.

 

I created a table to sort by column the Order. 

 

 

Then I tried the sort by axis/legend - still wrong

 

 

What am I missing or doing wrong here??

 

 

 

 

 

Need Help
  • Gabry's avatar
    Gabry
    1 year ago

    Here is the pbix .

    Please select the Priority column, then click on Sort by and choose the Order column.

     

9 Replies

  • Gabry's avatar
    Gabry
    Super User
    1 year ago

    Hey Anonymous 

    can't you just add a number before the text? 
    Like 0 - Low, 1 - Medium, 2 - high ecc?

    Not a satisfactory solution?

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Won't work as the priority column has a relationship with the main table of the same name. 

       

       

       

       

       

       

       

      • Gabry's avatar
        Gabry
        Super User
        1 year ago

        Don't modify the column used for the relationship, but add a new column in the table Prioritisortorder with the number as prefix, then use this new column for the visual leggend.

         

        Now I'm thinking that if you sort the priority column by order column should work also.

        Go in the data view, then select the priority column, then sort by order column