How to sort Legend by y-axis within line chart?

[jaryszek]

Hello,

still looking for a solution how to sort line chart like that:

So as you can see i can sort by Date Hierarchy which is nice. 

But Legend is sorted alphabetically, not by Y-Axis values (costs). 

But I can not sort by Legend and some kind of measures to be sorted and applied. 
Any magician can help? 

How to write Daxes to achove it?
O maybe there is some other visual which will handle it for me (free one). 

Will be very greatuful!

This is my model:
https://drive.google.com/file/d/14lpEWK-MQ6JMU5_15WVh8Gv22AiGvdpR/view?usp=sharing

Best,
Jacek

[Pragati11]

Hi @jaryszek 
Unfortunately, sorting Legends by Y-axis values is not supported on the default tooltips for the visuals.

You can create a custom tooltip and use it as sorted by y-axis values.

I created a Custom tooltip page with Date and Legend and values.

Sorted the table visual on custom tooltip by Sum of Cos in billing currency.

Added this custom tooltip as a tooltip on the line chart.

When you hove, you see legend values are in descending ouder of y-axis values.

Just adding a small video to showcase ow it will change with X-axis granularities but still maintain the legend sorting by values.

I am also attaching the PBIX file download link here.

https://we.tl/t-9rthucYZEf

Hope this solution helps.

[jaryszek]

thank you, no possible to add some measure to do this? 

Let me keep this topic open.

Best,
Jacek

[Pragati11]

Hi @jaryszek 
I can't think of a way using measures to do this.