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.
Good day,
A query, using the "Card with Startes by OKVIZ" card in power bi desktop, can a conditional be added to display the value "zero" (0) when in this case the real balance is zero? Since in the metric you should not have an IF to return zero, in the event that it has to be shown, I need to use this card and since the metric does not bring a value, it has to show me zero.
It is necessary for the zero to appear when the metric does not bring value, the card should not be left empty.
The IF should not be added in the metric, that is why I am asking to have a condition option in the card to add the zero value
Hi @ClaudioL
From what I can see Cards With States doesn't have the functionality you want.
It is able to check for a value but not a blank and I don't see that it can display custom messages/values either. The 'messages' it describes are actually icons.
So I would use the IF statement to display what you need.
Regards
Phil
Proud to be a Super User!
Hi @ClaudioL ,
Try
NewMeasure = IF(ISBLANK([Measure]),0,[Measure])
If you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ClaudioL
I don't understand the problem. What do you mean by this : in the metric you should not have an IF to return zero
Do you want the string "zero" displayed instead of the number 0?
If so then you could use a measure like this
Measure = IF(MIN('Table'[Index])=0,"Zero",MIN('Table'[Index]))
If that's not what you want please explain again with more detail and provide an example of the result you want.
Regards
Phil
Proud to be a Super User!
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 |
---|---|
98 | |
98 | |
80 | |
76 | |
66 |
User | Count |
---|---|
135 | |
109 | |
104 | |
83 | |
73 |