Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
KAITHA
Frequent Visitor

Stacked Area Chart Legend & Tooltip Order - Reversed

Hi, 

I have this area chart for 10 customers for their monthly sales volume. In the chart, the customer with biggest volume is placed at the bottom and that with lowest volume is at the top. However, in the legend and tooltip, the order is reversed. Customer with biggest volume appared at the top of the list and that with lowest volume appeared at the bottom of the list. Could you please advise how I can visually match the order of legend/ tooltip the order of the stacked area chart?

 

Thanks.

Regards,

KA

PBI to ask community area chart legend.jpg

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@KAITHA , Check for any option under three dots, usually Legends can only be ordered by ascending order or by sort column

View solution in original post

4 REPLIES 4
rjhartop
Helper II
Helper II

v-lionel-msft
Community Support
Community Support

Hi @KAITHA ,

 

v-lionel-msft_1-1620006770759.png

For ‘Legend’, it is impossible to change its sort order in the current version of ‘Stacked area chart’ .
For ‘Tooltips’, we can create custom tooltips.

--Custom tooltip

v-lionel-msft_2-1620007018476.png

 

Best regards,
Lionel Chen

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

 

 

amitchandak
Super User
Super User

@KAITHA , Check for any option under three dots, usually Legends can only be ordered by ascending order or by sort column

Hi @amitchandak Yup I have checked the options under three dots. But it doest work. There is only options to sort by either month or sales volume in ascending or descending order, but not by customer names in this stacked area chart case. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.