Reg: Issues in Conditional formatting icons by using field values

[Anonymous]

Hi everyone,

 I created the measure to show the column values with icons. the measure is

Arrow =

var _change =[This Week]-[Last Week]

return

SWITCH (

TRUE(),

_change > 0, UNICHAR(129145),

_change = 0, UNICHAR(129146),

_change < 0, UNICHAR(129147)

)

I am able to see the icons while i added as new column in a table view..If i added vlwk column with conditional formatting by field value with this measure the icons is not displaying..

kindly check this screenshot for your refrence.Kindly help me as soon as possible

Thanks & regards,

poornalingam a

[v-xiaotang]

Hi @Anonymous 

Not very clear. Please check the picture bellow,

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , I am sure I got it correctly

create a color measure

Arrow color =
var _change =[This Week]-[Last Week]
return
SWITCH (
TRUE(),
_change > 0, "green",
_change = 0, "blue",
_change < 0, "red"
)

Then in conditional formatting, you have to use it with "field value" and choose the color measure  -

Refer to my video for steps if needed:https://www.youtube.com/watch?v=RqBb5eBf_I4

Or try the icon formatting in table and matrix visual

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/