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 got a stocked column chart with Year on X - axis , Total sales as Value and Product Type as Legend, I have sorted the X axis by Year but the legend are displying in alphabetic order, How could I sort the legend by total sales in (ASC/DSC).
Solved! Go to Solution.
Hi @Anonymous ,
I'm afarid that you can submit this idea to https://ideas.powerbi.com/forums/265200-power-bi-ideas to make it coming sonner based on it may not supported currently.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Please make sure whether the data type pf Year you have put in X-axis is a sigma(∑) value like Whole number, Decimal number or Fixed decimal number. If so, you cannot use sort by function in stack column chart. You can change the Year data type into Text to try again. Here is my tested result:
For further information about sort by, you can refer the following Microsoft document that could help you:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@v-yingjl , When you sort by Total Sales, the Year is not coming in order,
I want to sort the X axis with year in ASC/DSC and Sort the legend by total Sales in DSC.
I'm not sure whether it is possible ?
Hi @Anonymous ,
I'm afarid that you can submit this idea to https://ideas.powerbi.com/forums/265200-power-bi-ideas to make it coming sonner based on it may not supported currently.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Got to three dots and check in options, you can choose column
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |