Forum Discussion
Matrix table visualization and summing based on opposite axis
1. only if you do crossjoins. Blanks are preferred to 0 for rendering
2. depends on the dimension values for your row and column fields, but should be possible.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi lbendlin,
Thank you for willing to take a look!
1. I have tried to use cross joins, but have been struggeling unfortunately.
2. I have added a replication of my .pbix fle with test data in the following google drive link. I think this is the fastest way to share what I have and the Excel file I'm trying to replicate (see sheet 2 of the Excel file).
The pbix. and Excel file:
https://drive.google.com/drive/folders/1WU5ECWvimSIOpzHr6LWXKN21O-QQcHFm?usp=sharing