"Show items with no data" and "Percent of Grand Total"

[SPAC]

Hello,

In regards to what is shown on the subject line, is there a workaround to enable when combining the two? I want to be able to show all items even with no data when using the "percent of grand total" on my stacked column chart. At the moment, Power BI is stating that when I combine the two, that it is not compatible.

Please assist and thank you for your time.

[lbendlin · Accepted solution]

To report on things that are not there you need to use disconnected tables and/or crossjoins