Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
Wondering if I can condition format a Line chart in power bi or alternatively if there is any custom visual to use.
Appreciate your help.
kind Regards,
Chiru
Your post has been changed because invalid HTML was found in Hello there,
I am following your option to solve the graph, but there are some parts that do not conform to reality, I indicate it in the screenshot.
I would appreciate your telling me what I may be doing wrong. Thank you.


Hi @chiru5262 ,
We create a sample and you can refer it.
1. Create a line chart using value. And configure an alert line.
2. Then we can create a measure using IF function.
greater than 20 = IF(CALCULATE(SUM('Table'[value]))>20,CALCULATE(SUM('Table'[value])),BLANK())
Put the measure to line chart and change its color, the result like this,
If it doesn't meet your requirement, Could you please show the exact expected result based on the tables that we have shared?
BTW, pbix as attached.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
How can I achieve if the data before the current one is lower, the color is black, and if the data is less than the current one, the color is red.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
72 | |
67 | |
51 | |
38 | |
26 |
User | Count |
---|---|
89 | |
52 | |
45 | |
39 | |
38 |