Forum Discussion
Bar Chart Y-axes
Hi
I can't change my Y axes from percentage, I just want to show the count.
I have tried to change the column to number, text, decimal number but no luck
Best regards
Tony
This happens because the visual is either set to "Show as Percentage" or has automatically switched to a 100% Stacked Bar/Column Chart. In Power BI, any 100% stacked chart always shows the Y-axis as a percentage, no matter what type of data you have. That’s why changing the column’s data type didn’t help.
Make sure you are NOT using:
100% Stacked Column Chart AND 100% Stacked Bar Chart
AND Switch to Clustered Column Chart, OR Clustered Bar Chart
4 Replies
- amitchandak
Super User
TonyHansson , it may happen because the format at the visual or element level is set. You need to check that
Y-Axis - Value -> FormatThat should correct, also check, if needed Property-> format
Hans-Georg_PulsHi TonyHansson ,
could it be that you have choosen one of the "stacked to 100%" charts? Another reason could be an option at your y-xis value as shown below:
- 123abc
Community Champion
This happens because the visual is either set to "Show as Percentage" or has automatically switched to a 100% Stacked Bar/Column Chart. In Power BI, any 100% stacked chart always shows the Y-axis as a percentage, no matter what type of data you have. That’s why changing the column’s data type didn’t help.
Make sure you are NOT using:
100% Stacked Column Chart AND 100% Stacked Bar Chart
AND Switch to Clustered Column Chart, OR Clustered Bar Chart
Hi
Thank you, yes I have choosen wrong 100% Bar Chart
Regards
Tony
