Show items with data only using POWER KPI MATRIX VISUALIZATION

[aicirtap027]

Hi All,

I have this table with filters and whenever i click a filter there are metric names that is still showing but no data at all. For example i choose CONSUMER EMEA then the metric name is still there but no data, how can i eliminate this metric name without data? Please help.

[TeigeGao]

Hi @aicirtap027 ,

You can try to use the IF() function judge if other data is blank, if they are blank, then display Blank() in this cell.

Best Regards,

Teige

[aicirtap027]

Hello @TeigeGao  could you please give me an example or syntax of the IF function for my problem? Thanks