I have Matrix table with list of places by week.
Values are based on one measure.
Now I would like to highlight the cells that are lower than data ("Data" is measure too):
My conditional measure:
Conditional Formating =
[Measure 1] < [Data], "red",
But the output seems to be correct only for the first column not for all... what kind of filter or condition shall I add to have the output by week.