Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
The row will only be hidden if all measures return BLANK()
I realize it could be solved by unchecking "Show items with no data".
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.
Hi,
Share the download link of the PBI file and show the problem there clearly.
The row will only be hidden if all measures return BLANK()
User | Count |
---|---|
73 | |
70 | |
38 | |
24 | |
23 |
User | Count |
---|---|
96 | |
93 | |
50 | |
41 | |
40 |