Forum Discussion
Effective data presentation - Actual vs. Budget
Hello,
How would you recommend to represent the following data:
3 Measures: Actual, Budget, Var%
2 Dimensions: Department, Month
I would like to show Actual vs. Budget over time (12 months) for 6-7 Departents - without creating separate chart for each department.
Any ideas/samples would be very welcome!
Thanks a lot!
Michael
3 Replies
- GilbertQ
Super User
Hi Anonymous
Have a look at this data story and it almost describes what you are after.
Create Dynamic Periods for Fiscal or Calendar Dates and Dynamic Month Names for Charts
As well as the sample PBIX to download.
Thanks, GilbertQ
Not exactly what I was looking for.
I am trying to show the data without my users have to choose/click on anything
Any ideas are appreciated!
Michael
ElliotPPost Prodigy
What do you mean exactly sorry?
If you just to want to show the story over time of how to value evole. You could create a bar chart, one value being actual, one being budget and a line for the %var (variance? if so, you can use the powerbi analytics feature for this, or if you want to show the difference between the two, create a measure simply 'Table1'[Actual]-'Table1'[Budget])
Keep it all in the original data table and you can filter by the department comfortable (department as the legend).
If you don't have a date table, I'd reccomend one from the azure marketplace called the ExtendedCalendarUS.
In terms of how the departments evolve, you can apply the principles above and find a chart which suits you.
If you attach a pbix, we could try having a go for you if you'd like?
