Support required for Measure or Column in Power Bi Visual

rgpsathish — Fri, 10 Jan 2025 05:24:34 GMT

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

Re: Support required for Measure or Column in Power Bi Visual

speedramps — Fri, 10 Jan 2025 17:16:02 GMT

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

Re: Support required for Measure or Column in Power Bi Visual

rgpsathish — Thu, 16 Jan 2025 02:56:18 GMT

Thank You speedramps your quick support.

topic Re: Support required for Measure or Column in Power Bi Visual in DAX Commands and Tips

Support required for Measure or Column in Power Bi Visual

Re: Support required for Measure or Column in Power Bi Visual

Re: Support required for Measure or Column in Power Bi Visual