The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have a calcuated column in Power BI that I use it to display in Report "Visual Card" that shows SUM value of that column (Delta Hrs Per Day & FTE Needed). I only want to show the value in that "Visual Card" if the SUM is Negative Value and dont show if the SUM is Positive Value in those columns, can anyone help with the IF statement or Contitional Card or anything that i can use?
Below is the Card that i use in the Visualization area
Below is the Column from the "Data" table
Solved! Go to Solution.
Hi @chintu94 ,
In case the SUM value in the visual is a measure, you could use the following DAX:
Measure2 = IF ( [Measure] > 0, "", [Measure] )
Otherwise you could also create a measure like this:
Measure = IF ( SUM ( table[col] ) > 0, "", SUM ( table[col] ) )
The "" you could substitute with BLANK(), too if that works for you.
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
Thank you so much
Hi @chintu94 ,
In case the SUM value in the visual is a measure, you could use the following DAX:
Measure2 = IF ( [Measure] > 0, "", [Measure] )
Otherwise you could also create a measure like this:
Measure = IF ( SUM ( table[col] ) > 0, "", SUM ( table[col] ) )
The "" you could substitute with BLANK(), too if that works for you.
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
User | Count |
---|---|
25 | |
10 | |
8 | |
7 | |
6 |
User | Count |
---|---|
32 | |
12 | |
10 | |
10 | |
9 |