How to add dynamic vertical reference line in a Line Chart.
I want to mark previous day in a line with a blue line , also the data label should be blue for yesterday and today.
I have tried to do it with Line & Column Chart (pbix attached), but the width of the band is big.
This is what I want:
If this is difficult , how to change the data label colour only for yesterday and today (without line)
Dynamic Vertical Reference line in Line Chart.pbix (169.8 KB) (upload://aIeU51eN51rFCIPTOONxmFkZqnI.pbix) (169.8 KB) SAMPLE.xlsx (40.5 KB)