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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Constant Line in 100% Stacked Charts

How can I reorder the 3 lines - in progress/ in time/ overdue. That in time is on the bottom- overdue in the middle and in progress on the Top.

PBI - reorder of a 100pct stacked chart.JPG

1 ACCEPTED SOLUTION
Anonymous
Not applicable

No directy way to do it. 

 

Is your compliants field is a calculated column? If it is, you can try the following workaround.

 

Example below:

 

Say you need to change the Gender order from F -> M to M -> F and Gender info is stored in a calcuated column.

2018-10-24_16-40-43.png

 

 

Select Enter Data to create a new Gender Table with an Order column that mark the order of M is higher than F.

2018-10-24_16-44-23.png

 

 

Save the table and then create relationship between this new Gender table with the original table.

2018-10-24_16-45-29.png

 

 

After that, go to the new Gender table, select Gender column and then select Sort by Column and choose by Order column.

2018-10-24_16-46-42.png

 

 

Then go back to your report, use the Gender column from the new Gender table to replace the original gender column.

2018-10-24_16-48-37.png

 

 

This time you can get the new order.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

No directy way to do it. 

 

Is your compliants field is a calculated column? If it is, you can try the following workaround.

 

Example below:

 

Say you need to change the Gender order from F -> M to M -> F and Gender info is stored in a calcuated column.

2018-10-24_16-40-43.png

 

 

Select Enter Data to create a new Gender Table with an Order column that mark the order of M is higher than F.

2018-10-24_16-44-23.png

 

 

Save the table and then create relationship between this new Gender table with the original table.

2018-10-24_16-45-29.png

 

 

After that, go to the new Gender table, select Gender column and then select Sort by Column and choose by Order column.

2018-10-24_16-46-42.png

 

 

Then go back to your report, use the Gender column from the new Gender table to replace the original gender column.

2018-10-24_16-48-37.png

 

 

This time you can get the new order.

Anonymous
Not applicable

refer to below link - last 3 posts in that thread

 

https://community.powerbi.com/t5/Desktop/stacked-graph-order/td-p/222496

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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