Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
108 | |
104 | |
83 | |
73 |