sort legend

[Alonso_96]

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.

[v-deddai1-msft]

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

[FrankAT · Accepted solution]

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)