Hello, I want to create a 100% stacked bar chart with a centered center. The data contains satisfaction figures and I would like to make it clear at a glance which components are good and which ones do not. Below is an example of how I like it. Only the legend is not sorted correctly. I hope somebody here has a solution.Thank you very much!Greetings, Tiemen

Hi Anonymous, Not sure if I'm understanding your question correctly, when I make a table with the information that I see on the image you posted, I get the exact image as you have it. Do you want to highlight the center values? Do you want to have your information in a diffent order? Sorry for the questions but as you can see I achieve the same as you. MFelix

Maybe a custom visual like Table Sorter or Tornado? https://app.powerbi.com/visuals/

Can you go to this way it will help you I hope? Go to data view panel ->modling ->sort columns (ASC/DSC). Thanks

Not sure what metric you are using in that graph but you should be able to wrap it in an ABS in order to always return a positive value.

gopichilla Greg_Deckler MFelix Thank you for your response! To further illustrate my robleem, I have further developed the example. If I use the 100% stacked bar chart, I get the following without any adjustments. It is not as clear as to which parts the assessment is good or very good.After a small adjustment (the negative and neutral ratings give a -1 score) I get the following bar chart.However, in the bar chart I want to start the order of the reviews to start with very bad instead of neutral as is the case now. In addition, I want to show the scores as a positive number. So at the first part, 11% 7% and 14% instead of -11% -7% and -14%. I hope this explanation makes my problem clearer.

Centered 100% stacked bar chart | Microsoft Fabric Community

12 Replies

MFelix
Super User
9 years ago
Hi Anonymous,

Not sure if I'm understanding your question correctly, when I make a table with the information that I see on the image you posted, I get the exact image as you have it.

Do you want to highlight the center values? Do you want to have your information in a diffent order?

Sorry for the questions but as you can see I achieve the same as you.

MFelix
Greg_Deckler
Community Champion
9 years ago
Maybe a custom visual like Table Sorter or Tornado?

https://app.powerbi.com/visuals/
gopichilla
Resolver III
9 years ago
Can you go to this way it will help you I hope?

Go to data view panel ->modling ->sort columns (ASC/DSC).

Thanks
Anonymous
Not applicable
9 years ago
gopichilla Greg_Deckler MFelix

Thank you for your response! To further illustrate my robleem, I have further developed the example. If I use the 100% stacked bar chart, I get the following without any adjustments. It is not as clear as to which parts the assessment is good or very good.

After a small adjustment (the negative and neutral ratings give a -1 score) I get the following bar chart.

However, in the bar chart I want to start the order of the reviews to start with very bad instead of neutral as is the case now. In addition, I want to show the scores as a positive number. So at the first part, 11% 7% and 14% instead of -11% -7% and -14%. I hope this explanation makes my problem clearer.
- Greg_Deckler
  Community Champion
  9 years ago
  Not sure what metric you are using in that graph but you should be able to wrap it in an ABS in order to always return a positive value.
  - Anonymous
    Not applicable
    9 years ago
    Thnx Greg_Deckler I will try it out!
RMO
Advocate I
5 years ago
Have you been able to find a fix for this issue? I'm able to center the chart, however the sorting for the negative values is reversed.
- MFelix
  Super User
  5 years ago
  Hi RMO ,
  
  Are you using a column to have the legend on your values or are they separate measures?
  
  If you are using different measures your need to place them in the order you need so the sorting is correct. If you have a column that you use for legend you need to add an additional column to sort them out and your chart will be correct.
  - RMO
    Advocate I
    5 years ago
    Thanks for the response. The issue isn't with the legend not sorting, because that's sorting correctly. It's the chart itself. If you look at OP's first image, the negative values in the chart are 3,2,1 when they should be 1,2,3. It's essentially correct because the values are ordered (-11 < -14) but we're looking for a workaround that reverses the order without taking the absolute value.