Forum Discussion
Matrix Visual - Conditional Formatting
- 1 year ago
I found this video and this gave me the solution I need. https://www.youtube.com/watch?v=FOZQ0L8JxwI
Thank you for sending that. I reviewed and tried the dax measures but did not get a result. I am looking to idenfity the highest sales day when in the matrix when the day of the week, month and store are selected from the slicers. I understand that creating a measure to calculate the MAX value would be the way to achieve this. However, i'm not sure how to get that data. I have tried a measure that just does MAX(table[actual]) but I am not able to add that measure to the conditional formatting. It isn't available for me to select for some reason. Do you know why that measure isn't a field value the formatting can be based on?
- vwiles841 year agoHelper III
I found this video and this gave me the solution I need. https://www.youtube.com/watch?v=FOZQ0L8JxwI