Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
Please download my example PBIX solution from Onedrive 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
Please download my example PBIX solution from Onedrive 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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |