Forum Discussion
Post ProdigyHow to display zero using Measure or column value (when there is no value)?
I would prefer you don't do that. Instead, enable "Show items with no data".
Super UserThe best approach is not to do this. The blanks are there for a reason, and filling them with 0 skews the data.
The second best approach is to use disconnected tables and cross joins.
Post ProdigyThank you so much for your feedback. I think first option is not my option at this moment.
How do we go about doing with the second options (using disconnected tables and cross joins)?
Thanks.
- lbendlin
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-Forum/ba-p/963216
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/1447523