Forum Discussion
No Conditional formatting option on Data color
For some reason there is no option to use Conditional Formatting for coloring "line chart" lines.
Is DirectQuery having anything to do with it? Or could there be another reason for not showing it?
5 Replies
- parry2k
Super User
Anonymous unfortunately conditional formatting is not available for line charts, the trick is to create a column chart, apply the conditional formatting, and then switch it to line visual, data points will use conditional formatting.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- v-angzheng-msft
Community Support
Hi, Anonymous
Yes, line charts are not suitable for conditional formatting. The above switch is also not feasible.
What kind of user case needs to use conditional formatting for the line chart?, can you please elaborate on what you are trying to achieve or post sample data and expected result so it is clear on what needs to be implemented so that i may work out with a workaround?Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ELWAdvocate II
Just noting that I really wish PowerBI would add conditional formatting functionality to line charts. The bar chart workaround doesn't seem to work any longer.
