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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.