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.
Is there a way to change the font colour of a text column [BRAG STATUS] with the values "Green", "Amber" & "Red"
I'm able to use conditional formatting to get a value by field for the first values (see pic attached) but it doesn't pick up the amber colour:
I've even tried to use a switch function to change the HEX colours but I still cant quite get it
Conditional Colour Format = SWITCH(TRUE(),MAX(audit_results[BRAG STATUS])="Green",1,MAX(audit_results[BRAG STATUS])="Amber",2,MAX(audit_results[BRAG STATUS])="Red",3)
Any help on this would be great!
Thanks,
Solved! Go to Solution.
@Anonymous
BRAG STATUS | Column2 |
Red | 1 |
Amber | 2 |
Green | 3 |
Red | 4 |
Amber | 5 |
Green | 6 |
Red | 2 |
DAX measure
Conditional_Colour_Format =
VAR __status =
CALCULATE ( FIRSTNONBLANK ( audit_results[BRAG STATUS], TRUE () ) )
VAR __color =
SWITCH ( __status, "Green", "#4CAF50", "Amber", "#FFC107", "Red", "#f44336" )
RETURN
__color
@Anonymous
BRAG STATUS | Column2 |
Red | 1 |
Amber | 2 |
Green | 3 |
Red | 4 |
Amber | 5 |
Green | 6 |
Red | 2 |
DAX measure
Conditional_Colour_Format =
VAR __status =
CALCULATE ( FIRSTNONBLANK ( audit_results[BRAG STATUS], TRUE () ) )
VAR __color =
SWITCH ( __status, "Green", "#4CAF50", "Amber", "#FFC107", "Red", "#f44336" )
RETURN
__color
@Anonymous , As per this Amber is supported
https://blog.crossjoin.co.uk/2018/08/10/colour-names-supported-in-power-bi-conditional-formatting/
Hexcode you have to return with #. Hope you are using "Field" option and measure. Make sure you created a measure not column
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
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"
)
I have this measure but it cant load the data for the visual:
HI @Anonymous ,
See if this helps.
https://exceleratorbi.com.au/conditional-formatting-with-a-text-field-in-power-bi/
Regards,
Harsh Nathani
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |