- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
"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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
To report on things that are not there you need to use disconnected tables and/or crossjoins
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
To report on things that are not there you need to use disconnected tables and/or crossjoins

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
01-23-2025 02:55 AM | |||
Anonymous
| 12-07-2020 05:49 AM | ||
04-20-2023 12:12 AM | |||
04-04-2025 12:35 AM | |||
05-04-2023 01:13 PM |