Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe 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.
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.
@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
Proud to be a Super User!
Hi @Anonymous
Or use ISBLANK() , you can substitute "" or "-" for 0
IF( ISBLANK([YourMeasureName]) , 0, [YourMeasureName] )
Regards
Phil
Proud to be a 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
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.
@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
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
83 | |
69 | |
68 | |
39 | |
37 |