Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a line chart with future values. Is there anything I can do to change a colour of the line from blue to orange where the date is greater than today?
X-axis : month_year
Y-axis : sum app_amt
Solved! Go to Solution.
Hi @M_SBS_6
If your line chart doesn't have a legend field, you can create a measure for the sum of future values. Just like below. Add it to Y-axis. You will have two Y-axis fields now. Then you can format their colors separately.
Future Amt = IF(SELECTEDVALUE('Table'[Date])>=TODAY(),SUM('Table'[app_amt]))
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi @M_SBS_6
If your line chart doesn't have a legend field, you can create a measure for the sum of future values. Just like below. Add it to Y-axis. You will have two Y-axis fields now. Then you can format their colors separately.
Future Amt = IF(SELECTEDVALUE('Table'[Date])>=TODAY(),SUM('Table'[app_amt]))
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |