Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am working on a budget vs actual reporting dashboard. We do monthly planing, so we want to be able to see how the whole year is planned out (ie there may be a planned spike in November) but only want to see the actuals up to the selected month. I have every other visualization interact with the month & year drop down, but if I do so for the line graph I just have two dots.
Is there a way to have the budget show for the entire year but limit the data shown for actuals? Without the beforementioned limitations, there are financials posted to months that haven't closed yet, causing issues like below where they have negative expenses for March, which is not true.
Here is how our old graph looked in excel:
And the work around with a separate hidden pivot chart; essentially erroring out the actuals after the selected month:
Thank you!
FalconBudget
Hi @FalconBudget ,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He
Howdy, this has not yet been resolved. The answer you posted was interesting but not quite what I was looking for. I am going to keep trying different things.
Hi @FalconBudget ,
Ok, if your problem could be sloved, don't forget to close this topic.
Regards,
Daniel He
Hi @FalconBudget ,
What is your desired result for your line graph? Could you mean to dynamic change the x-axis for your visual by the data slicers?
If so, you could refer to below link:
https://community.powerbi.com/t5/Desktop/Dynamic-change-in-X-Axis/td-p/86167
If it still could not help you, could you please share your pbix to have a test and post your desired result if possible?
Regards,
Daniel He
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |