Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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:

rabbit__0-1673243015549.png

 

Dataset:

rabbit__1-1673242731442.png

Display in Matrix

rabbit__0-1673242669066.png

Any suggestions please?

Thank you

2 REPLIES 2
BeaBF
Impactful Individual
Impactful Individual

@Anonymous Hi! Can you attack the pbix file?

 

BBF

Anonymous
Not applicable

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

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors