0

Power BI Line chart

Here I'm using line chart in PowerBI, including Plan vs Actual value. If Actual value is greater than the Plan value Line color need to change to Green and If Actual value is less than the Plan value Line color need to change to red. But After updating Power BI version, the conditional formatting option is disabled. See in the image. How to do Conditional formatting in this case.

1 Answer 1

0

For line chart, we can't add conditional formatting on it. You can do that on clustered column chart. However, you can only add one measure in the y-axis field. You can create a measure

Measure = sum('Table'[actual])-sum('Table'[plan])

then set up the conditional formatting

enter image description here

at last, you can the chart to line chart

enter image description here

As you can see, we can only set up the color for marker. We can't do it for line.

Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.