cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Sorting on Stocked column chart

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).

Stocked_Sort.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Sorting on Stocked column chart

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.

View solution in original post

4 REPLIES 4
Highlighted
Super User IV
Super User IV

Re: Sorting on Stocked column chart

Got to three dots and check in options, you can choose column



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Microsoft
Microsoft

Re: Sorting on Stocked column chart

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:

When the Year is a sigma value, I cannot find sort by function in the visualWhen the Year is a sigma value, I cannot find sort by function in the visual

After I changed the data type into text, I can use sort by function normally in the visualAfter I changed the data type into text, I can use sort by function normally in the visual

For further information about sort by, you can refer the following Microsoft document that could help you:

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-button

 

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.

Highlighted
Anonymous
Not applicable

Re: Sorting on Stocked column chart

@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 ? 

 

 

Highlighted
Microsoft
Microsoft

Re: Sorting on Stocked column chart

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.

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors