cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rodfernandez Frequent Visitor
Frequent Visitor

line chart with target area

Hello

Is there a way to show this graph but instead of the 3 constant lines (Min, Target and Max) with a colored area?

 

target.png

1 REPLY 1
Community Support Team
Community Support Team

Re: line chart with target area

Hi @rodfernandez ,

 

It is not available to highlight Min, Target and Max values with colored area in a line chart. 

 

As a workaround, you could try Area chart with below similar measures.

Min line = CALCULATE(MIN(Sales[Price]),ALLSELECTED(Sales))
Max line = CALCULATE(MAX(Sales[Price]),ALLSELECTED(Sales))
Avg line = CALCULATE(AVERAGE(Sales[Price]),ALLSELECTED(Sales))

1.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.