Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
Proud to be a Super User!
1. Select the Table
2. Goto Formatting Options -> Field formatting -> Dropdown (Select the variable) -> Value decimal Places.
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.
Proud to be a Super User!