Reply
Frequent Visitor
Posts: 10
Registered: ‎10-10-2018
Accepted Solution

stacked col chart

Hi

I am new to power bi and community as well. I have created a stacked column chart where x axis is week number, values are sales qty and legend is type of product. The issue is : the sales qty on individual bars follow the order as in legend. I want the largest sale on bottom and lowest sale on top in each individual bar. Can anybody help, please?

(My apology if I have posted it 2nd time,  there was some registration issue which caused me to doubt the posting of my question.)

Thanks!!


Accepted Solutions
Highlighted
Established Member
Posts: 255
Registered: ‎03-31-2016

Re: stacked col chart

hi @powerbinewbee71

 

You can't order stacked bar charts but Ribbon charts do order by quantity like you describe.

 

ribbon.PNG

 

 

View solution in original post


All Replies
Highlighted
Established Member
Posts: 255
Registered: ‎03-31-2016

Re: stacked col chart

hi @powerbinewbee71

 

You can't order stacked bar charts but Ribbon charts do order by quantity like you describe.

 

ribbon.PNG

 

 

Community Support Team
Posts: 5,684
Registered: ‎09-21-2016

Re: stacked col chart

Hi @powerbinewbee71,

 

No. Currently, it is not possible to order the stacked bars based on actual value rather than legend item. Maybe you could submit this feature request at ideas page.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 10
Registered: ‎10-10-2018

Re: stacked col chart

Thanks, Yuliana.