Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.

 

 

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

Need Help

4 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    5 years ago

    Hi Anonymous 

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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

    • PhilipTreacy's avatar
      PhilipTreacy
      Icon for Super User rankSuper User
      5 years ago

      Hi Anonymous 

      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