Right chart for using bars, lines, and area

[BackesLucas]

Good afternoon, folks.

I need to create a chart that on the X Axis has a calendar, and on the Y Axis some information:

• 2 bars that would be quantities in the month, with legend (Inlet and Output);
• 1 Line with Accumulated Input only;
• And here my difficulty, I need to highlight 2 (or more) months, as these are important;

Here is an example of what I would like to have in PowerBI:

Please, can you suggest to me how to achieve my goal?

[ryan_mayu · Accepted solution]

@BackesLucas 

I tried in PBI, one dot can't generate shadow.

here is a workaround for you .

create a new column

Column =

var _x=maxx(FILTER('Table','Table'[Date]=EARLIER('Table'[Date])-1 ),'Table'[important])

var _x2=maxx(FILTER('Table','Table'[Date]=EARLIER('Table'[Date])+1 ),'Table'[important])

return if(_x="x"||'Table'[important]="x"||_x2="x","x")

pls see the attachment below

[Deku]

You can try using a combo chart with reference lines. Reference lines were enhanced last month and might meet your requirements