Is it possible to change font color for only a part of the string in Matrix value cell of power bi?
I have a dax expression where I am concatenating strings with other dax measures. Net WP = "Net Written Premium " & FORMAT([CY YTD],"$#,##,,.0M") & " vs. " & FORMAT([PY YTD],"$#,##,,.0M") & " " & MAX(dim_Date[Year]) -1 & " "& [Net Wr Premium YOY Title] Result look like this: Is any way I can change the font color for only the last part of the string? ([Net Wr Premium YOY Title]) so it should look like this:
Conditional Formatting font text Amber
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,
