Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |