Need help designing a Power BI Matrix report

[PowerBI_Ed]

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

[lbendlin · Accepted solution]

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

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/1447...

[Anand24 · Accepted solution]

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

[lbendlin · Accepted solution]

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

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/1447...