Forum Discussion

myasirma's avatar
myasirma
Regular Visitor
8 years ago
Solved

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 reference

  • Anonymous's avatar
    Anonymous
    8 years ago

    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's avatar
    garvicasas
    8 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      garvicasas
      Helper I
      8 years ago

      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