Custom Matrix - help needed

KG1 — Thu, 19 Mar 2020 12:10:08 GMT

I need to be able to create a matrix like this which plots a value inside a matrix based on its score.

Could anyone offer some advice as to whether this would be possible and how it can be done?

Many Thanks

Re: Custom Matrix - help needed

Anonymous — Fri, 20 Mar 2020 08:30:03 GMT

I don't think you can do customize with matrix plot features.
For your scenario, I'd like to suggest you write a measure with if statement to check current row and column label to find out the score, then you can replace this score to other values based on condition.

Measure = VAR currRowLable = SELECTEDVALUE ( Table[Row] ) VAR currColLable = SELECTEDVALUE ( Table[Column] ) VAR _score = CALCULATE ( SUM ( Table[Score] ), FILTER ( ALLSELECTED ( Table ), [Column] IN currColLable && [Row] IN currRowLable ) ) RETURN IF ( _score > 10, 2, IF ( _score < 10 && _score > 5, 1, 0 ) )

Regards,

Xiaoxin Sheng

topic Re: Custom Matrix - help needed in Developer

Custom Matrix - help needed

Re: Custom Matrix - help needed