Matrix values Decimal places issue

[myasirma]

Hi,

In Power BI Desktop have a matrix and removed decimals from values by setting Data Type as "Whole Number" and Format as "General" and deciamal places as "Auto" which worked well but when published to Power BI service decimal values showing in report. Can someone have the clue to resolve the issue, snapshots attached for reference

[Anonymous · Accepted solution]

Hi,

Try to change the decimal places as 0. I think Decimal Places AUTO will show 2 places.

I'm just giving an Idea.

[Anonymous · Accepted solution]

Hi,

Try to change the decimal places as 0. I think Decimal Places AUTO will show 2 places.

I'm just giving an Idea.

[garvicasas · Accepted solution]

that was what i was thinking, changing decimals places to 0 it's better than converting to a whole number, since you are not losing information, and moreover it keeps this way when u "publish" it