Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic color in a line graph with two values

I have a line graph with two dynamic values, but I need the color of the circle to change according to the legend that I stipulate, whether it is above or below the goal.

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

    You can create a calculated column as below, then put it on Legend fields of line chart.

    Column = IF('Table'[QTY]<[Goal value],"Below", IF('Table'[QTY]=[Goal value],"Goal","Above"))

    Best Regards

    Rena

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

    You can create a calculated column as below, then put it on Legend fields of line chart.

    Column = IF('Table'[QTY]<[Goal value],"Below", IF('Table'[QTY]=[Goal value],"Goal","Above"))

    Best Regards

    Rena