How to change the number of decimals in a show value as grand total in power bi

[Anonymous]

Hello All,

Anyone who could help me on how to change the number of decimals in Percent  in Show Value As grand total in power bi as it's defaulted to two decimal places. I want to have it whole number. 

I based my number of total thru perfomance level meaning counting off numbers of performance either Threshold, excellence or target. Then need to get percent as whole number. I am using line and clustered column chart.

Please  advise. 

[Anonymous]

1. Select the Table

2. Goto Formatting Options -> Field formatting -> Dropdown (Select the variable) -> Value decimal Places.

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,

Is this what your are looking forward to seeing? PBI puts it in as 1.5 and on the upper chart, I changed it to 2. 

  

It turns out that if you set the Display Units to "None" and put your cursor in the "Value decimal places" (even though it is grayed out) and type "0" the display changes.

If this solves your issue, please mark this as the solution.

@Nathaniel_C