Forum Discussion

smjzahid's avatar
smjzahid
Helper V
3 years ago

Custom sort for legend not working with conditional column

I have a 100% stacked column chart in PBI desktop and on the legends well I have a column with below shown values (Text Values)   I do not want this to be sorted using the values in this column. Ho...
Need Help
Show and Tell
Tips and Tricks
Junaid11's avatar
Junaid11
Helper V
3 years ago

Hello smjzahid ,
To sort based on Legend. 

1)Click on the visual and press 3 dots at the top right corner of visuals as shown in picture.

2)Click on the "Sort by" dropdown and select "Value".

3)Choose the sort order as either "Ascending" or "Descending" based on your preference.

4)Click "OK" to apply the changes.

smjzahid's avatar
smjzahid
Helper V
3 years ago

NO that will sort on the values in the legends column in this case the legen column is Status and it has values as shown in below snip so its sorting those values alphabetically with ALDE/DPE CEM Review Process starting with A first and followed by other, Thats not my requirement

 

I want the GREEN COLOUR (HSF Accepted by NRG to be the first and then followed by others (please read my requirement above)

 

 

  • jritenour's avatar
    jritenour
    Regular Visitor
    1 year ago

    Did you ever find a solution to this? Having a similar issue with a Table refusing to use the "Last" summarization option's conditional formatting (since for some reason I can't conditional formatting to the Total row) even though my custom order is applied.