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
Peekay_Num
Helper I
Helper I

Currency Column

I have a currency column, Sum, uncategorized.  I want it show values where it is $0 , they are not showing.  How can I make them appear?

2 REPLIES 2
djurecicK2
Super User
Super User

Hi @Peekay_Num ,

 Try selecting the relevant field, then set Summarizaion to "Don't Summarize"

 

djurecicK2_0-1675720551037.png

 

Peekay_Num
Helper I
Helper I

Asking another way, I simply want to show the financial amount associated with my category. One cell, one value.  If it's zero I want to see $0.  I don't a way to bring in the value without assigning min, max, count, avg, sum....etc  How to I just ask for the value,  No calculation?

Helpful resources

Announcements
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.