Please forgive me, I#m really new to Power BI…
Is it possible to highlight the first/blank missing entry in a Power BI matrix?
Say last year we have 10 salespeople working 20 days per month and we’re tracking the changes in the number of available days and want to conditional format any changes (e.g. annual leave, sick absence, joiners/leavers). I have managed to create a couple of measures to identify the change in the number of days and apply the conditional formatting.
However, if a salesperson leaves and there are no further entries for the salesperson, the matrix is showing the cells as being blank (no more data for that salesperson) and either refuses to apply any formatting (there isn’t a zero/blank to format) or it formats all the remaining periods, but I only want the period of the actual change to be hihglighted – e.g. if salesperson A went from 20 days to 0 days in October (and left the company), I only want to highlight October as the period of change, I don’t want to highlight October to date.
Hopefully that makes sense and someone can help.
Thanks.