Forum Discussion
Helper IValues for cells with no data
This has been an ongoing issue and i've spent hours working on this, but no luck. As you can see in the table, the green empty cells are cells that have no data associated with them, so they are blank. The "show no data" option won't work for this as there is no data. And, I can't add a "+0" because it will ignore my data range filter. I want to show "100" for all blank cells and it work within any data range i choose.
1 Reply
- lbendlin
Super User
To report on things that are not there you need to use disconnected tables and/or crossjoins
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
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.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
