Budget Line

[Anonymous]

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:

1. A bar chart, x-axis is the category, y-axis is the $ amount. The budget line will give a value based on each category
2. 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

[Anonymous · Accepted solution]

The way I did it was to append the budget data to the data I have. Since the budget is a new column, anything that isn't from budget will be null, therefore the budget will not be overstated or understated as opposed to using merge. This worked for me for now.

[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.

[v-xuding-msft]

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.