"Value decimal places" setting not working correcly for matrix

[db400]

For my matrix, I have "Value decimal places" set to "0" but my percent of total row is still showing decimals. What am I doing wrong?

[v-xinruzhu-msft · Accepted solution]

Hi @db400 

1.Please check that the the series you have selected is the '% of total' e.g 

2.You can try to format your measure to the following

e.g 

Measure 2 = FORMAT(DIVIDE(SUM('Table'[Count]),SUMX(ALLSELECTED('Table'),[Count])),"0%")

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983]

Hi @db400 
This happens because you use automatic aggregations.
You can get the same results with measures.
Unfortunately, I am out of the limit of images that I can add to the discussions, so I prepared som sample files and recorded the screens.
Link to recorded screens: mp4 

Link to a sample file: PBIX 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.