Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm trying to make a multi row matrix...but I keep getting these blank rows.
See screenshot below for detail. How do I remove the blank (in red) rows.
Solved! Go to Solution.
You may take advantage of Show Categories With No Data or Visual level filters.
You may take advantage of Show Categories With No Data or Visual level filters.
My expectation this will be in your data somewhere. When PowerBI is considering the logic of your matrix, either you have a set of rows where the department is blank or empty, or you have a set of data that can't match between tables to get a result for the department name.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |