Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello I need to make my line chart so it could color the negative values that is bellow the axis in red.
Now I have line chart with multiple items in legend and every line has a different color. What I want is like a IF statement, IF value <=0 line color red. Can I do that?? I'm attaching a screenshot of my chart.
Hi @TomasPac ,
By my tests and research, I'm afraid that there is no conditional formatting for line chart in power bi currently.
You could vote this similar idea here and add your comments there to improve Power BI and make this feature coming sooner.
What I want is like a IF statement, IF value <=0 line color red. Can I do that?? I'm attaching a screenshot of my chart.
You idea is good, but you have legend value in the line chart so I think the IF function will not work.
Normally, to achieve conditional formatting, we could use the measure with If as a workaround if you do not have legend value in the line chart.
Best Regards,
Cherry
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |