Forum Discussion
KR300
Helper III
Helper IIIShowing different color to a second line when combining the data using CONCATENATE & UNICHAR(10)
I have 5 columns R0und, Planned Start Date, Planned End Date, Actual Start Date, Actual End Date I am combining all the data using a calculated column Planned / Actual Timelines 4 = Var _Roun...
You cannot colour a substring
HI KR300,
You can try to unpivot these date fields to convert them to attribute and date values, then you can use this attribute field on legend to assign different colors based on their attribute group:
Unpivot columns - Power Query | Microsoft Learn
Regards,
Xiaoxin Sheng