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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Hooi_livenow
Frequent Visitor

Why the amount is unable to show in numbers

Hi All, 

 

I have a new measure and the amount will need to be put into a card. But the amount is unable to show as the full number. What did I do wrong here? 

 

Hope someone can help. Thanks 

Hooi_livenow_0-1663204637750.png

Reagards, Hooi 

4 REPLIES 4
jdbuchanan71
Super User
Super User

What is the DAX code for the measure you are showing in the matrix?

@jdbuchanan71 , here is my formula. Even if I don't have Dax formula for this, it also no total value for the row 

Hooi_livenow_0-1664156781237.png

 

jdbuchanan71
Super User
Super User

You just need to change the formatting of the measure.  The number is so small it is showing in scientific notation.

-1.96E-8 = -0.0000000196

@jdbuchanan71 , THanks for reply. 

 

However, I have values in my table but why the total amount of the column is zero? 

 

Hooi_livenow_0-1663570033436.png

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! It's time to submit your entry.

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.