Reply
SPAC
Frequent Visitor

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

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.

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

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

avatar user

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)