cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
myasirma Visitor
Visitor

Matrix values Decimal places issue

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 referencePowerBIDesktop.pngPowerBIService.png

2 ACCEPTED SOLUTIONS

Accepted Solutions

Re: Matrix values Decimal places issue

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 Regular Visitor
Regular Visitor

Re: Matrix values Decimal places issue

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

2 REPLIES 2

Re: Matrix values Decimal places issue

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 Regular Visitor
Regular Visitor

Re: Matrix values Decimal places issue

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