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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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]) )

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors