Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have this Matrix Table.
Here is my Values Measure
Here is RankCauseGrouping
What do I need to to eliminate the blanks in my table?
The first table you posted correctly displays the results. If you don't want to see the blanks, then set it up like the second table you posted. If you want to use the first table structure with no blanks, please produce the table manually (using Excel) to show what you expect to see. I suspect doing this will help you realise that they way it is in the OP is the correct result.
You can simply turn off the totals for the visual
Yes I can turn totals off but there is still the blank issue?
There are 4 rows in your table including the total row. Every row has at least 1 valid number to display. What result do you expect?
I may need to leave as a vertical table, since Top causes are not the same for each year. I was hoping to show the Top 3 Causes by Count for each year. Totals are strange as they muxt be picking up totals of causes outside the Top 3?
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!