Support required for Measure or Column in Power Bi Visual

[rgpsathish]

Hi Expert,

I need your support for make the visualization for below attached samples data.

Note : Group status colour coding need to change based on Team KPIs colour coding, Group Status should be take minium values

[speedramps · Accepted solution]

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

[rgpsathish]

Thank You @speedramps your quick support.