Forum Discussion
Using 'Is Not Blank' does not properly filter out blanks in Matrix visual
Hi, I am trying to exclude blank rows from a matrix visual. Using the Advanced Filtering 'Is Not Blank' option is not working properly. How can I remove these blank rows from this matrix?
You'll see the filters applied on the right (green) and the blank rows circled in red that are still showing up when they shouldn't be.
Solved this using the solution here on switching from Outline to Tabular:
https://community.fabric.microsoft.com/t5/Report-Server/Matrix-visual-shows-extra-blank-rows-abnormal/m-p/3937164/highlight/true#
2 Replies
Solved this using the solution here on switching from Outline to Tabular:
https://community.fabric.microsoft.com/t5/Report-Server/Matrix-visual-shows-extra-blank-rows-abnormal/m-p/3937164/highlight/true#Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
