Forum Discussion

aicirtap027's avatar
aicirtap027
Frequent Visitor
7 years ago

Show items with data only using POWER KPI MATRIX VISUALIZATION

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.

 

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • TeigeGao's avatar
    TeigeGao
    Solution Sage
    7 years ago

    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's avatar
      aicirtap027
      Frequent Visitor
      7 years ago

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