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

The Fabric community is now in read-only for platform upgrade. Learn more

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
djurecic
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 and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.