Forum Discussion
Color formatting by other columns
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
2 Replies
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!
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
