Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
tdinh
Frequent Visitor

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:

tdinh_0-1726251678199.png

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

 

tdinh_1-1726251932829.png

tdinh_2-1726252152920.png

 

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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

View solution in original post

4 REPLIES 4
tdinh
Frequent Visitor

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

Anonymous
Not applicable

Hi, @tdinh 

I create sample table and had a test:

vyohuamsft_0-1726462828969.png

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

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

vyohuamsft_1-1726462898175.png

 

Here is my preview:

vyohuamsft_2-1726462941885.png

vyohuamsft_3-1726462952291.png

 

 

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
Super User
Super User

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
lbendlin
Super User
Super User

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.