Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I am trying to convert the following line chart to format anything above my .2% threshold as colored and anything below as grayed.
Is there a way to format the line colors like below or no?
Solved! Go to Solution.
Hi @seanprincivalle ,
Line charts can be customized with line colors, but only one line color is supported for the time being. You can create a value to implement two colors of the line.
Here are the steps you can follow:
1. Place the following fields in the line chart.
Format – Lines – Color – change line color.
2. Create measure.
Measure =
var _sum=SUMX('Table',[Value])
return
IF(
_sum>=0.002,_sum,BLANK())
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @seanprincivalle ,
Line charts can be customized with line colors, but only one line color is supported for the time being. You can create a value to implement two colors of the line.
Here are the steps you can follow:
1. Place the following fields in the line chart.
Format – Lines – Color – change line color.
2. Create measure.
Measure =
var _sum=SUMX('Table',[Value])
return
IF(
_sum>=0.002,_sum,BLANK())
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 161 | |
| 132 | |
| 117 | |
| 79 | |
| 54 |