Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |