Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Card visual disapear when data is not available

Hi, I need to use a card visual (or similar) with in my Tachometer gauge. when data is N/A Tacho gauge disapears automatically but the cards I placed inside them just show Blank. now, my question is...
  • TomMartens's avatar
    TomMartens
    7 years ago

    Hey,

     

    I'm referring to the title of this thread.

     

    You can use a measure (you have to use the latest version of Power BI - June 2019 releaese), that returns an empty string when anoter measure is blank. Create a measure like so:

    vizAid Card Title (no title when measure is blank) = 
    var theValue = [Total Quantity]
    return
    IF(ISBLANK(theValue) , "" , "The amount is " & theValue)

    Then you can assign this measure to return the text, this text will be used as title:

    Please be aware, that you have to come to close to the region of upper arrow to make "3 little dots" appear, using these dots, you can enter the conditional formatting.

    From this dialog you can select the measure from the table it is assigned to:

     

    Hopefully this is what you are looking for.

     

    Regards,

    Tom