Forum Discussion
Solved
Matrix Table - Formatting
Hi all, I hope all is well! I have a client that would like a specific form of formatting for a Matrix table they'd like to implement: They would like to highlight the numbers in the 2025 column th...
You will need a measure that picksup the previous year's value and compare that with the current and build conditional formatting on to of it.
Below is just a sample conditional formatting measure to be used as field. Actual measure will vary depending on the structure of your model.
conditinal formatting = VAR _ly = CALCULATE ( [aggregation], FILTER ( ALL ( 'table'[year] ), 'table'[year] = MAX ( 'table'[year] ) - 1 ) ) RETURN IF ( [aggregation] <> _ly, "yellow" )Please refer to this sticky post on how to get a better answer - https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
