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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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