Forum Discussion

piotrgrendus87's avatar
piotrgrendus87
Helper I
3 years ago
Solved

Hide Function

Hello All. Can You give some advise how to hide blank text when there is no data in table, but when in that same time i am using a hide function. Hide function Summary KPIs = IF (    ISFILTER...
Need Help
  • bolfri's avatar
    bolfri
    3 years ago
    Try this one:

     

    Hide function Summary KPIs =
SWITCH(TRUE(),
ISBLANK([Your measure name]),"#FFFFFF00",
NOT(ISFILTERED ('Accountflex Data'[Dealer ID and Name Filter])),"#FFFFFF00",
"#000000")



     

bolfri's avatar
bolfri
Solution Sage
3 years ago
Try this one:

 

Hide function Summary KPIs =
SWITCH(TRUE(),
ISBLANK([Your measure name]),"#FFFFFF00",
NOT(ISFILTERED ('Accountflex Data'[Dealer ID and Name Filter])),"#FFFFFF00",
"#000000")