Solved: How to edit the decimal points in the % of grand t...

Anonymous · ‎04-23-2020

How can I edit the decimal points in the % of total, this is not a measure

v-kelly-msft · ‎04-27-2020

Hi @Anonymous ,

A workaround for you:

Calucalte the percentage of grand total in a calculated column,then you can edit the decimal point as you need:

And you will see:

calculated column% of grand total

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Anonymous · ‎07-15-2021

1. Select the Table

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

v-kelly-msft · ‎04-27-2020

Hi @Anonymous ,

A workaround for you:

Calucalte the percentage of grand total in a calculated column,then you can edit the decimal point as you need:

And you will see:

calculated column% of grand total

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Greg_Deckler · ‎04-24-2020

Yeah, I've come across this before and I could not really find a way.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

How to edit the decimal points in the % of grand total option?