Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Card showing Blank

Hi

 

I have a Dashboard that is run off of an excel spreadsheet. Here is my problem I have a Notes section where there currently is nothing so when it gets loaded into my Power Bi dashboard it says blank. How can I make this not say anything when its blank and say the note is when there is writing? 

 

Thanks 

 

Need Help

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Perhaps:

     

    Measure = 
IF(ISBLANK(MAX([Notes]))," ",MAX([Notes])