Forum Discussion

Alonso_96's avatar
Alonso_96
Frequent Visitor
5 years ago
Solved

sort legend

Hi,

 

I have this graphic:

But i want to order the legend in descending order according to the number of processes that each user is performing, not alphabetically.

  • Hello @Alonso_96

    what to concatenate the calculated value with the associated name like this (as an example)

    523 - Georgina Liliana Sánchez Romano

    366 - Edith del Carmen Sanchez Roja

    ...

    With kind greetings from the city where the legend of the 'Pied Piper de Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

2 Replies

  • FrankAT's avatar
    FrankAT
    Community Champion

    Hello @Alonso_96

    what to concatenate the calculated value with the associated name like this (as an example)

    523 - Georgina Liliana Sánchez Romano

    366 - Edith del Carmen Sanchez Roja

    ...

    With kind greetings from the city where the legend of the 'Pied Piper de Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support

    Hi Alonso_96 ,

     

    You can create a calculated column for the number of processes, then  sort the legend column by the new column. Or you can try the solution in https://community.powerbi.com/t5/Desktop/Sort-legend/m-p/262395 to create a new table for legend and create relationship between fact table and legend table.

     

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

     

    Best Regards,

    Dedmon Dai