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
Hi kcdavi01
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.