Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I've tried what you said but it still didn't work, no option for conditional formatting, even after switching between a column chart and a line chart. Same results for both new visuals and existing ones.
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.
Well, some of the lines on my line chart are subsets that were separeted from the main sets of values. And the line chart can do it, it shows all the subsets.
But, to better visualize the subsets from the same set, I would like to make them the same color instead of showing random colors.
I already have a method of creating hex color codes for different sets and the same hex color codes for subsets within a specific set, but I can't apply them because there isn't conditional formatting.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |