Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Decimal change to Whole number not working in Matrix

Hello helpers,

 

I have dataset orginally build as Decimal (10,2) format numbers, after i loaded to Power BI, i changed the number to Whole Number,

Now the dataset shows as whole number fine, but the numbers in visuals still show 2 decimal 0s.

And when i select the column, it shows as Whole number 

Formatting:

 

Dataset:

Display in Matrix

Any suggestions please?

Thank you

2 Replies

  • Anonymous Hi! Can you attack the pbix file?

     

    BBF

    • Anonymous's avatar
      Anonymous
      Not applicable

      All good, thanks BeaBF, I changed the data format in Visualisation decimal to 0, and worked.