Forum Discussion
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 that differ from the numbers in the 2024 column.
- [In the example below this would be the Likelihood and Controllability scores.]
- They want to have these differences stand out from those numbers that did not change.
Is there any way to do that with a Matrix table or in general?
Thanks a bunch in advance!
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
8 Replies
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 all,
Hope all is well! Thanks a bunch for providing!! 😄 I had a feeling it was some sort of measure/column to implement lol
I attempted applying the Measure structure provided but think this is where my PBI limitations start to show haha
I entered the below Formula but Im not exactly getting the result I was looking for. Could I have entered the formula incorrectly? (with conditional formatting applied)
conditinal formatting2 =
VAR _lys2 =
CALCULATE (MAX(
'RPNs-2'[Value - Copy]),
FILTER(ALL('RPNs-2'[RPN Year]),'RPNs-2'[RPN Year]= MAX('RPNs-2'[RPN Year] )
))
VAR _ly2 =
CALCULATE (MAX(
'RPNs-2'[Value - Copy]),
FILTER(ALL('RPNs-2'[RPN Year]),'RPNs-2'[RPN Year]= (MAX ( 'RPNs-2'[RPN Year] ) - 1 ) )
)
RETURN
IF ( _lys2 > _ly2, "yellow" )Heres a lil sample of the dataset Im working with for consideration:
Thanks in advance again for any guidance you can provide!!
Use Field Value for Format style, not rules. The measure will return yellow or blank depending on the current context.
You need a new measure that is the variance of the two years. Then set conditional formatting on the column you want to highlight based on that measure.
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.
Hi kcdavi01
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi kcdavi01
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
