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.
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
Solved! Go to Solution.
@KAITHA , Check for any option under three dots, usually Legends can only be ordered by ascending order or by sort column
You can vote for this idea:
https://ideas.powerbi.com/ideas/idea/?ideaid=2a748865-164d-ec11-a3ee-281878bda47d
Hi @KAITHA ,
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
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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |