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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Selwynster
Helper II
Helper II

Reverse order in Stacked Column Chart

Please see image below.

Is it possible to sort the bars in reverse to the Legend?

 

Capture.PNG

1 ACCEPTED SOLUTION
Anonymous
Not applicable

The stated solutions to date did not work for me. Here's what worked for me.  

 

how_to_sort_in_powerBI.png

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

The stated solutions to date did not work for me. Here's what worked for me.  

 

how_to_sort_in_powerBI.png

v-jiascu-msft
Employee
Employee

Hi @Selwynster,

 

This order inherits from the order in the original table. Please refer to stacked-column-chart-legend-order. I also cite my answer below.

We can sort the legend column [Change Reason] in the original table. Then the order will be applied in the visual. Please give it a try.

1. Create a proper order column if you don't have one.

2. Change the sort order by "Sort by column".

3. Done. Please refer to the snapshot below.

stacked_column_chart_legend_order

 

 

Best Regards,

Dale

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

Thanks @v-jiascu-msft

But this would sort both the Legend and bars accordingly.

I will look into your other options.

Thanks

Hi @Selwynster,

 

Do you look for the same solution as the author does that I mentioned in my last post? To make the color of both the bars and the legends in the same order. Take your snapshot for an example, the colors of legend from top to bottom is "Green, Black, Red, ...", then the colors of bars from top to bottom should be the same. 

 

If so, I'm afraid it's a limitation for now. Please refer that post for details.

 

Best Regards,

Dale

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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