How to show % on stacked bar chart?

[erihsehc]

currently can only show number in decimal point instead of % on stacked bar chart (the source data is on % format). Also, how to show the % in the fourth row, not to hidden the number when the bar area is small, please help thanks

[GilbertQ]

Hi @erihsehc

You you created a measure for your value or not?

And I do think that when the value is too small to fit into the area it might not be shown. But you can test it out with the formatting options under Data Label

[erihsehc]

thanks quavaq

Actually, the source data directly feed to Power BI from like SQL, without measure, is that possible to show % directly? it is quite time consuming to change all source by using measure.

Also, the fourth bar, the % is very small like 3%, but I still want to show the % on power bi for presentation (i have checked the Data Label but still not working) is that any way to solve?. thanks 

[GilbertQ]

Hi @erihsehc

What you could do is when you import the data in the Query Editor you can change the data type on the column to %

With regards to the 3% I am not sure if this is possible due to being so small and not having enough space to fit in the actual numbers.

[erihsehc]

thanks. I have used the query editor to change the data to % and applied the data, however, the number in the bar chart still not updated to %. headache

[GilbertQ · Accepted solution]

Hi @erihsehc

Did you also look to change the Format property under Modeling and then Format in the Ribbon?

As well as did you enable the Customize Series under the Data Labels as shown below?

[erihsehc]

Thanks quavaq, my 1st query solved, can show the % now

For 2nd query, I have enabled the customized series already, can not make the number visible