Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
85 | |
66 | |
51 | |
45 |
User | Count |
---|---|
216 | |
89 | |
82 | |
66 | |
57 |