Forum Discussion

NMil's avatar
NMil
Advocate I
4 years ago
Solved

Advanced Card format text when (Blank)

Hi all,

 

Due to the normal cards being unable to left allign, and the 'card with states' being slow and unable to 'bold' text I am currently using 'advance card' visualisation on my dashboard.

 

I have (Blank) values pop up as i am using the same measures on a table. If I don't use the (Blank) as a result in the formula, the matrix table includes the entire date table.

 

I want the (Blank) values font to appear as white so it looks blank in the dashboard when there's no data.

 

Is there a way to do this?

 

Why are the cards functions so bad 😕

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    NMil , usually conditional formatting does not work with blank. But if field values conditional formatting is supported in that visual, You can use this measure in conditional formatting using field value

    You can use

    measure = if(isblank([measure]), "white", "black")

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    NMil , usually conditional formatting does not work with blank. But if field values conditional formatting is supported in that visual, You can use this measure in conditional formatting using field value

    You can use

    measure = if(isblank([measure]), "white", "black")

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi NMil 

    Could you share some pictures of that visual and the dax expression in it? So that I can see if it can achieve this effect by changing part of the code.

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.