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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
Super User
Super User

@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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors