- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous
Click on the Measure in the Fields pane then in the Formatting area of the Ribbon, set the Format to Currency.
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.
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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]) )
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I love the "+0" trick, that totally works 😁
eg Sum(Table[value]) +0
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
The out put shld be "$162K" in this box. But I could not obtain this kind of output.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous
Click on the Measure in the Fields pane then in the Formatting area of the Ribbon, set the Format to Currency.
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.
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
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
12-18-2023 05:19 AM | |||
Anonymous
| 07-08-2024 03:25 AM | ||
02-08-2024 05:06 PM | |||
06-16-2024 03:22 AM | |||
07-22-2024 04:24 AM |
User | Count |
---|---|
121 | |
73 | |
59 | |
57 | |
44 |
User | Count |
---|---|
181 | |
120 | |
82 | |
65 | |
57 |