March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I have these below measures in card visuals. When there is nothing then is shows BLANK, I need 0 instead of BLANK-
1)
Solved! Go to Solution.
Hello @learner03 ,
You may add +0 at the end of your formula.
This may give you the desired results.
Cheers!
Vivek
Hi @learner03,
One of the ways I like to get around this is by using an IF ( ISBLANK ( .... ) , 0 , ( .... ) ) or IF ( (....) = 0 , 0 , .... For example:
IF (
CALCULATE (
CALCULATE (
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hi @learner03,
One of the ways I like to get around this is by using an IF ( ISBLANK ( .... ) , 0 , ( .... ) ) or IF ( (....) = 0 , 0 , .... For example:
IF (
CALCULATE (
CALCULATE (
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
@learner03 here is a great article from Radacad on this: https://radacad.com/replace-blank-with-zero-in-power-bi-visuals-such-as-card
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hello @learner03 ,
You may add +0 at the end of your formula.
This may give you the desired results.
Cheers!
Vivek
Instated of 0 I need to display the "?" mark. Can you assist for this
@SriLakshmi_46 you can add instead of using IF ( .... = 0 , 0 , .....) you will need to swap the middle 0 with IF ( .... = 0 , "?" , .... ). However, you can only do this where the column itself is text based and not a Whole Number or Decimal. Reasonbeing, Text (i.e. "?") is not a numeral and cannot be used in value-based measures, etc. Hope that makes sense?
Theo 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
125 | |
85 | |
69 | |
53 | |
44 |
User | Count |
---|---|
204 | |
105 | |
99 | |
64 | |
54 |