Create a target area in a line and clustered column chart

[Maladnik]

Hello, 

I am using a line and clustered column chart to represent production data. 

The clustered column chart is for daily production and the line chart is the daily cumulative. I want to create a target area for the daily production data. 

In the picture below i want to replace the purple and orange line with a green target area. Can somebody please help. 

Field:

•  I started using Power BI recently. Please let me know if I need to provide more info for you to help me 

[Ashish_Mathur]

Hi,

How should the target line's value be calculated.  Share that logic. Also, share the link from where i can download your PBI file.

[Maladnik]

Hi Ashish, the Target area would be the area between fixed upper and lower limit values. For example, UL = 50,000 & LL = 20,000.

[Ashish_Mathur]

Hi,

On the Analysis tab there is a provision to create a Constant line.