Forum Discussion
Budget Line
Hi,
I have a dataset with numerous categories, and each category has its own $ amount for each month. I am trying to add a budget line to each of the category in the same visual. This is what I want to be able to have:
- A bar chart, x-axis is the category, y-axis is the $ amount. The budget line will give a value based on each category
- When I filter it by different months, I want the line to be able to change according to the months I filtered
So far what I got is incomplete, as the budget line does not correspond to each of the categories, but rather a line of the sum of the whole budget.
Any ideas?
Thanks!
Daren
3 Replies
v-xuding-msftCommunity Support
Hi Anonymous ,
You could try using the visual of Bullet chart. It is very easy to implement your requirement.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- v-xuding-msft
Hi Anonymous ,
Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.