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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

How to show all blank values as hyphen or zero

Hi I need help from you on how to show the blank values in the card feature as hyphen or blank. 

 

Pls find the screen shot below.

 

zxavierdeloitte_0-1611823253777.png

 

1 ACCEPTED SOLUTION

@Anonymous 

Click on the Measure in the Fields pane then in the Formatting area of the Ribbon, set the Format to Currency.

curr-form.png

 

The Display Units shoudl be set to Auto so the card shows the K after the number, but if that doesn't show you can manually set it.

In the Format area of the Visualizations pane, open Data label and set Display units accordingly.  Auto should work.

curr-form2.png

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

5 REPLIES 5
PhilipTreacy
Super User
Super User

Hi @Anonymous 

Or use ISBLANK() , you can substitute  "" or "-" for 0

 

IF( ISBLANK([YourMeasureName]) , 0, [YourMeasureName] )

 

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


amitchandak
Super User
Super User

@Anonymous , add + 0 to you measure 

 

Example

Sum(Table[value]) +0

 

Or you can try

if(isblank(Sum(Table[Value])), "-", Sum(Table[Value]) &"")

 

or

 

if(isblank(Sum(Table[Value])),0, Sum(Table[Value]) )

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

I love the "+0" trick, that totally works 😁

eg Sum(Table[value]) +0

Anonymous
Not applicable

@PhilipTreacy @amitchandak 

THank you very much. It works but I have a problem that I couldn't put it with dollar sign in front and convert it into the format like "S122K" for example. 

 

zxavierdeloitte_0-1611882119898.png

 

The out put shld be "$162K" in this box. But I could not obtain this kind of output.

@Anonymous 

Click on the Measure in the Fields pane then in the Formatting area of the Ribbon, set the Format to Currency.

curr-form.png

 

The Display Units shoudl be set to Auto so the card shows the K after the number, but if that doesn't show you can manually set it.

In the Format area of the Visualizations pane, open Data label and set Display units accordingly.  Auto should work.

curr-form2.png

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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