Forum Discussion

babuInba's avatar
babuInba
Frequent Visitor
4 years ago
Solved

Filter matrix table - multiple column conditions

Hi Experts, I would like to filter only non blanks values from matrix table, given below snapshot FYI ( Filter only non blank rows based on overall score value) OVerall score is a measure, i tried ...
Need Help
Show and Tell
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi babuInba 

     

    Are "Test", "Test2" and "Overall score" measures? If they are measures, displaying them in a table visual instead of a matrix will make it easier. In the Filter pane, you can expand Overall Score field and select is not blank option to filter only non blank rows. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi babuInba 

 

Are "Test", "Test2" and "Overall score" measures? If they are measures, displaying them in a table visual instead of a matrix will make it easier. In the Filter pane, you can expand Overall Score field and select is not blank option to filter only non blank rows. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.