Forum Discussion

tdinh's avatar
tdinh
Frequent Visitor
2 years ago
Solved

Filter out rows with empty value from matrix visual

Is there a way to hide all rows with empty value in matrix visual? For example, Accountant Fee, Action Play Systems. All the display columns are measures. I tried forcing all empty value to 0 and cre...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    The row will only be hidden if all measures return BLANK()

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, tdinh 

I create sample table and had a test:

 Maybe you can create a calculated column, then put it in filter pane:

Display = IF(
    ISBLANK([Column1]) || ISBLANK([Column2]) || ISBLANK([Column3]), 
    FALSE, 
    TRUE
)

 

Here is my preview:

 

 

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.