Forum Discussion
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 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.
The row will only be hidden if all measures return BLANK()
4 Replies
- lbendlin
Super User
The row will only be hidden if all measures return BLANK()
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.
I realize it could be solved by unchecking "Show items with no data".
- Ashish_Mathur
Hi,
Share the download link of the PBI file and show the problem there clearly.
