Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
10 months ago
Solved

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

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 valu...
Need Help
  • Pragati11's avatar
    Pragati11
    10 months ago

    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.

     

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
10 months ago

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's avatar
    jaryszek
    Icon for Super User rankSuper User
    10 months ago

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

    Let me keep this topic open.

    Best,
    Jacek

    • Pragati11's avatar
      Pragati11
      Icon for Super User rankSuper User
      10 months ago

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

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 months ago

      Hi jaryszek,

      I would also take a moment to thank Pragati11 , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

      Appreciate if you could share the feedback on our Microsoft Fabric Ideas. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.


      Regards,
      Community Support Team.