Color formatting by other columns

[Anonymous]

Hello Power BI community,

is there any option to color format a column by more than one other column?

I have two tables:

The first contains in every cell one value and the GM1 should be the colored column.

Contract	Branch	Type	Team	GM1
1	30	OL	601	8
2	30	MDL	568	50
3	21	OL	234	80
4	5	Ol	34	23
5	5	MDL	500	15

The second table determines the color. I have to check if team,branch and type match with the first table and compare the percentage and the GM1 to determine the color. Team and branch are only optional fields thats why they are blank. I have to use the specialised type that means if team,branch and type 601,30,MDL matches with the first table i have to compare this percentage->Red and not 30,OL->green

Are they any ideas? Thanks in advance

[amitchandak]

@Anonymous , when you go to conditional formatting, You can choose a measure other than that column to the color group.

or create a measure like this and use it with Field option in coditional  formatting

color =
switch ( true(),
FIRSTNONBLANK(Table[commodity],"NA") ="commodity1" && sum(Table[Value]) >500,"lightgreen",
FIRSTNONBLANK(Table[commodity],"NA") ="commodity2" && sum(Table[Value]) >1000,"lightgreen",
/// Add more conditions
"red"
)

refer for steps

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[harshnathani]

Hi @Anonymous ,

Not very clear.

You can check

https://community.powerbi.com/t5/Desktop/Color-Conditional-Formatting-Matrix/m-p/959291

https://community.powerbi.com/t5/Desktop/Matrix-visual-color-conditional-formatting/m-p/1153577

https://www.youtube.com/watch?v=BbuikATa3ow

https://www.youtube.com/watch?v=MAISRa88bl0

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!