Forum Discussion
Matrix visual conditional formatting issue
Hi Nisha357
Thank you for reaching out to the Microsoft Fabric Forum Community.
Please try below points,
- Switched from MAX() to SELECTEDVALUE() so the measure works correctly for each row in the matrix. MAX() can give unexpected results when multiple values exist in the context.
- Used [Monthly Actual] and [Monthly Target] directly because they are already numeric. No need to use VALUE() or SUBSTITUTE(), which can cause comparison issues.
- Handled blank values by treating them as 0 to prevent errors and ensure the conditional formatting logic runs smoothly.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
Hi Nisha357
Thank you for reaching out to the Microsoft Fabric Forum Community.
Please try below points,
- Switched from MAX() to SELECTEDVALUE() so the measure works correctly for each row in the matrix. MAX() can give unexpected results when multiple values exist in the context.
- Used [Monthly Actual] and [Monthly Target] directly because they are already numeric. No need to use VALUE() or SUBSTITUTE(), which can cause comparison issues.
- Handled blank values by treating them as 0 to prevent errors and ensure the conditional formatting logic runs smoothly.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
Hi Nisha357
I hope the information shared was helpful to you. If your question has been answered, kindly mark the most relevant reply as the Accepted Solution. This small action can make a big difference for others who are looking for the same solution.
Hi Nisha357
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.
Hi Nisha357
Hope everything’s going smoothly on your end. We haven’t heard back from you, so I wanted to check if the issue got sorted. If yes, marking the solution would be awesome for others who might run into the same thing.