Support required for Measure or Column in Power Bi Visual

Please download my example PBIX solution from Onedrive here

Click here 

Add a conditional column to the query

Create two measures

Colour = 
var colour = MIN('Table'[Colour code])
RETURN
SWITCH(colour,
3 , "green",
2 , "yellow",
"red")

Cell name = 
// either display KPI or Team in cell

IF(ISFILTERED('Table'[KPI]),
SELECTEDVALUE('Table'[KPI]),
SELECTEDVALUE('Table'[Team])
)

Create a matrix visual and add conditional colour formating.

Note how the measure behaves.
The rows show the KPI but the total show the Team.

Set the matrix visual layout to Outline. This will flip the total line to the top, rather than the bottom 

Hide the row and column headers with white text 

Increase values and total font sizes

Create white grid lines

Congratulations, you have a visual !

I would be most garetful if you would click the [Accept solution] and the thumbs up button.

 Thank you