Change color of font within DAX measure based on WHERE clause.

[stevenmcginnis]

I have the following DAX for a measure which converts a number into a number of boxes based on how many 'project' are in the portfolio:

Boxes = REPT(UNICHAR(9632), COUNT('Portfolio'[Project]))

My question is, would it be possible to change the colour of the boxes within the DAX query based on another column. For example if I have another column called "value driver". So the logic would be for one value driver the boxes would blue, another red, and another green?

[amitchandak · Accepted solution]

@stevenmcginnis , try a color measure and use that in conditional formatting using field value option

I used icon and color in past

/////Arrow
Arrow =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, UNICHAR(9650),
_change = 0, UNICHAR(9654),
_change < 0, UNICHAR(9660)
)

/////Arrow Color
Arrow color =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, "green",
_change = 0, "blue",
_change < 0, "red"
)

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...