How to make values with no data stay in visual

[HSymes-Thompson]

I have budget information and actuals information. There are scenarios where there may be no actuals for something that was budgeted for the year, and likewise there may be actuals where we didn't budget for it. I'm trying to pull a visual together that shows this information. If I select the 'show values where there is no data' it expands the table massively to the point its useless. Is there something I can write in my formula to only show values where there is no data and they are related. Budget reference is the key that ties budget and actuals together. In the example below, you can see that we have spent £159 on Office B20, there was no budget for this. As soon as I bring in the Supplier Name from the budget table, the £159 figure disappears from the visual. The formula to get both YTD Actuals and Budget 2022 is just SUM('Overheads Data'[Debit/Credit]) and SUM('Budget table'[Value])

[Idrissshatila]

Hello @HSymes-Thompson ,

Try to right click on the field in the visual and select show items with no data.

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍

Follow me on Linkedin

[HSymes-Thompson]

I have this option applied which is why you can see the Office B20 line, but I am not sure why the £159 doesn't appear?