Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
@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.
@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.
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
103 | |
93 | |
64 | |
61 |