Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |