Filled Bar Chart showing Target and Actual Values in one bar

[natasha519]

Is it possible to get a bar chart that shows the target value and then actual value in one bar? Image attached for reference.

Sample data as follows:

Year	Actual	Goal
2023	15	25
2024	0	25
2025	0	25
2026	0	25
2027	0	25

[Gowtham_Selvam]

In power Query Editor, just unpivot the actual and goal columns.

Then choose the stacked column chart and drag the value in y axis and year in x axis.

If I answered the question,mark it as solution.

[v-zhangti · Accepted solution]

Hi, @natasha519 

You can try the following methods.

Measure:

@Goal = MAX(SUM('Table'[Goal])-SUM('Table'[Actual]),0)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.