Hide Function

[piotrgrendus87]

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 (

   ISFILTERED ('Accountflex Data'[Dealer ID and Name Filter])=TRUE(),"#000000","#FFFFFF00")

without selection

with selection

If there is data it works fine, but when there is no data a see something like this:

Conditional formating for this viusal not allow me to add more then one field value

Can You tell me how to fix this problem ?

Regards Piotr.

[bolfri · Accepted solution]

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")