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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
abukapsoun
Post Patron
Post Patron

Remove decimal from average

Hi,

 

I have a card displaying the average of a column, how can I remove the decimal number from the card? 

The card is currently displaying XX.YY .. I want to remove the YY. 

 

Thanks

1 ACCEPTED SOLUTION
BeemsC
Resolver III
Resolver III

Hello,

Select your measure/Make a measure using AVG function -> Go to Format: -> Change it to whole number.
Look at my attached photo if you cant find it:
voorbeeld 3.png

View solution in original post

1 REPLY 1
BeemsC
Resolver III
Resolver III

Hello,

Select your measure/Make a measure using AVG function -> Go to Format: -> Change it to whole number.
Look at my attached photo if you cant find it:
voorbeeld 3.png

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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