Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Reg: Issues in Conditional formatting icons by using field values

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

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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/

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    5 years ago

    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.