Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear all, can i change color for the below line chart based on my legend? Thanks
.
Solved! Go to Solution.
Hi @xiumi_hou ,
To create a calculated column as below.
Column = IF('Table'[value]<3,"0-2", IF('Table'[value]<7,"3-7","else"))
Then add it to legend in line visual.
If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Hi @xiumi_hou ,
To create a calculated column as below.
Column = IF('Table'[value]<3,"0-2", IF('Table'[value]<7,"3-7","else"))
Then add it to legend in line visual.
If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Conditional formatting yes for this, however you can use this technique.
https://exceleratorbi.com.au/line-chart-conditional-formatting/