Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
ClaudioL
Helper IV
Helper IV

Card with Startes by OKVIZ

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.

 

Snap 2021-03-19 at 11.45.45.png

 

It is necessary for the zero to appear when the metric does not bring value, the card should not be left empty.

4 REPLIES 4
ClaudioL
Helper IV
Helper IV

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


v-stephen-msft
Community Support
Community Support

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.

PhilipTreacy
Super User
Super User

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.