Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
rgpsathish
Frequent Visitor

Support required for Measure or Column in Power Bi Visual

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



rgpsathish_2-1736486641717.png

 

 

1 ACCEPTED SOLUTION
speedramps
Super User
Super User

Please download my example PBIX solution from Onedrive here

Click here 

 

Add a conditional column to the query

speedramps_0-1736528112357.png

 

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.
speedramps_1-1736528432246.png

 

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

speedramps_2-1736528497197.png

 

Hide the row and column headers with white text 

 

speedramps_3-1736528642660.png

 

Increase values and total font sizes

speedramps_5-1736528756918.png

 

 

Create white grid lines

speedramps_4-1736528705260.png

 

Congratulations, you have a visual !

speedramps_6-1736528892455.png

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

 Thank you

 

 

 

View solution in original post

2 REPLIES 2
speedramps
Super User
Super User

Please download my example PBIX solution from Onedrive here

Click here 

 

Add a conditional column to the query

speedramps_0-1736528112357.png

 

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.
speedramps_1-1736528432246.png

 

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

speedramps_2-1736528497197.png

 

Hide the row and column headers with white text 

 

speedramps_3-1736528642660.png

 

Increase values and total font sizes

speedramps_5-1736528756918.png

 

 

Create white grid lines

speedramps_4-1736528705260.png

 

Congratulations, you have a visual !

speedramps_6-1736528892455.png

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

 Thank you

 

 

 

Thank You @speedramps your quick support. 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.