Forum Discussion
binayjethwa
1 year agoHelper V
Backgroung gradient color conditional formatting for Row comparison for Matrix visual.
Hi, I have a matrix visual which has following items,. Rows : Domain Columns : Name Values : Measure Column Name has multiple values like , total completions , completion % , Novice , Asp...
Anonymous
1 year agoNot applicable
Thanks for the reply from parry2k.
Hi binayjethwa ,
Based on your description I created simple data and achieved the desired results, here are my steps:
1.Create simple data:
2.Create a measure, the values on the matrix can be ranked using RANKX:
color =
VAR _rank=IF(MAX('Table'[Name]) IN {"Advanced","Aspiring","Novice"},RANKX(FILTER(ALLEXCEPT('Table','Table'[Domain]),'Table'[Name] IN {"Advanced","Aspiring","Novice"}),[measure]))
RETURN
SWITCH(_rank,1,"#4A4A4A",2,"#808080",3,"#D3D3D3")
3.Conditional formatting of the measure:
4.The result is as follows:
Best Regards,
Zhu
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.