Forum Discussion

uSt's avatar
uSt
Regular Visitor
4 years ago
Solved

Table is empty show text as "No Data"

Hi Team,

 

I have table contains string and shoes as table if values blank shows as "no Data".

 

below pic is showing blank i want text "No data" (My team is members name )

 

 

Thanks,

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    uSt , You need to a card visual on top of it with a measure

    measure = "No Data"

     

    Then use the color measure for font and background of card visual using field value option in conditional formatting

     

    color font = if(isblank(count(Table[My Team])) , "000000", "FFFFFF00")

    color background= if(isblank(count(Table[My Team])) , "FFFFFF", "FFFFFF00")

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    uSt , You need to a card visual on top of it with a measure

    measure = "No Data"

     

    Then use the color measure for font and background of card visual using field value option in conditional formatting

     

    color font = if(isblank(count(Table[My Team])) , "000000", "FFFFFF00")

    color background= if(isblank(count(Table[My Team])) , "FFFFFF", "FFFFFF00")