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.
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?