Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

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

Syndicated - Outbound

@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

Syndicated - Outbound

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

Syndicated - Outbound

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Syndicated - Outbound

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

eg Sum(Table[value]) +0

avatar user
Anonymous
Not applicable

Syndicated - Outbound

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

Syndicated - Outbound

@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!


avatar 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!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)