Actual & Budget with Line and stacked area chart

[nmhung49]

Hi, Team

I want to create a chart like the picture below

Is it the visual possible in Power BI?

Please see attached file

Thank in advance

[Anonymous · Accepted solution]

Hi @nmhung49,

I'd like to suggest you extract the all the year part to a new table and add the 'budget' to these values, then you can use this new field on your chart as legends and write a measure formula with switch function to check and redirect the result to differential expressions based on current category values.

My Favorite DAX Feature: SELECTEDVALUE with SWITCH | Winston-Salem Power BI User Group (pbiusergroup...

Regards,
Xiaoxin Sheng

[amitchandak]

@nmhung49 , Not exact the same. Both Month as axis, Year as Legend, and budget on secondary axis as line. In the line visual. Check for and the option will region below the line.(Usually there in Area)

[nmhung49]

Can you be more specific about it. I did it but it didn't work