Forum Discussion
Need help designing a Power BI Matrix report
How can I develop a power bi matrix report where the row and column attributes show in the Matrix even if the value is zero
To report on things that are not there you need to use disconnected tables and/or crossjoins
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523PowerBI_Ed ,
You simply pull the fields into rows, columns and values of the matrix and the zeros will appear. Zeros are still data values and they will still appear in the matrix visualization unlike blanks or nulls.
If it helps, you can enable the "Show items with no data" option.
2 Replies
- lbendlin
Super User
To report on things that are not there you need to use disconnected tables and/or crossjoins
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 - Anand24
PowerBI_Ed ,
You simply pull the fields into rows, columns and values of the matrix and the zeros will appear. Zeros are still data values and they will still appear in the matrix visualization unlike blanks or nulls.
If it helps, you can enable the "Show items with no data" option.