The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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! Go to Solution.
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-abnorma...
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-abnorma...
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...