Change y axis format of 100% stacked column chart

[ngut47]

Hello, 

Is it possible to change the format of the y axis for the 100% stacked column chart?  

For example instead of showing 10%, 20%, in the y axis... Change y axis format to 10 %, 20 %,... With a space between? 

Thank you 

[v-yiruan-msft]

Hi @ngut47 ,

Has your problem been solved? If yes, could you please mark the helpful post as Answered? It will help the others in the community who have similar problems to yours to find a solution as soon as possible. Thank you.

Best Regards

[ngut47]

The results of my measure are count values. So putting these values into the chart, automatically changes to precentage proportions. But it's not the format of the values i need to change but the y axis. It's more of an cosmetic formatting. Because the chart has an automatic y axis i guess, so it shows 0-100%. But instead of having the number and the % together I want them seperate. Because 100% and 100 % has two different meanings. 

[v-yiruan-msft]

Hi @ngut47 ,

The data type of the field applied to the Y-axis must be numeric, and here you want to change 100% to 100 %, which becomes a Text type. For these default visuals in Power BI, there is no suitable option found to customize the format of the Y axis...

Maybe you can review the following blog by using R visual and check whether it can achieve your requirement.

CUSTOM AXIS FORMATS IN POWER BI USING R VISUALS

Best Regards

[amitchandak]

@ngut47 , In model view under property you have an option for format. Try to format you measure there and check does it take that on axis https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings