Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
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👍
Proud to be a Super User! | |
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |