Filter out rows with empty value from matrix visual

[tdinh]

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 created a new Display measue (True/False) to identify which rows are empty/0. I plan to use Display measure as filter and filter out False value, however I can only drag the measure to Filter but can't select the value to filter out

Current Table:

My attempt to identify empty rows but I can't filter out.

[tdinh]

I realize it could be solved by unchecking "Show items with no data".

[Anonymous]

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.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file and show the problem there clearly.

[lbendlin · Accepted solution]

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