Hi,
I have a report with manuctures listed in rows with dollar sales for this year versus last. I noticed blank row is showing up on the bottom of the table. I didnt see the blank manufacturer data in source table. Under filter manufacturer i also didnt see any blank option to exclude. Is there anyway to exclude this row in matrix table. Appreciate any help!
@dokat In Power Query Editor, select the drop down in the column header for one of the columns that shows a blank only in this row. Uncheck the blank value.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
@dokat In Power Query Editor, select the drop down in the column header for one of the columns that shows a blank only in this row. Uncheck the blank value.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Power BI Monthly Update - April 2025
Check out the April 2025 Power BI update to learn about new features.
NEW! Community Notebooks Gallery
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Fabric Community Update - April 2025
Find out what's new and trending in the Fabric community.
