Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Icon Conditional formatting by measure in table do not encode

Hi, i'm trying to use created Measure for icon formatting and use it in table. However, after creating a measure and applying it into conditional formatting options in table, my unichar icons are not being encoded(as below). Does anyone know how to solve that? - I want to stay on this solution - usage of measure for icon conditional formating - as standard conditional based on rules is to limited to do that. 

Below my measure, result in table and conditional formatting. 

 

 

 

Thanks 

Need Help

1 Reply

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    Hi, Anonymous 

    I have a similar situation here. It seems that field value for icon conditional formating doesn't support for unicode symbol and svg xml (even they can work normally on my table measure column).

    As a workaround , you can try to use icon IDs(there are over 60 icons in the built-in icon set)  or img url to replace unicode symbols /svg xml. 
    releted thread: https://community.powerbi.com/t5/Desktop/What-are-the-icon-IDs-In-July-update/m-p/752053 

    Sample:

     

    VCU icon condition1 =
SWITCH (
    TRUE (),
    [VCU] < 0, "https://image.emojipng.com/618/3323618.jpg", // url
    [VCU] > 0, "https://emojigraph.org/media/emojidex/red-triangle-pointed-down_1f53b.png",
    "4CircleLow" //iconid
)

     

    In fact ,you can also try to format by rules without conditional measure for icon formatting.

    Best Regards,
    Community Support Team _ Eason