Forum Discussion
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 =
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
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.
- 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")
1 Reply
- 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")