Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Excel Icon Rules in power BI (Bullets)

Hello, I've been trying to reproduce the table of this link, but unfortunately I am not able to create the red/green/yellow bullets and I cant see the  Retail Analysis Sample in my power BI version....
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    HI Anonymous ,

    You can add a calculated column with unichar function to display symbol icon, then you can enable conditional formatting on it to display different color based on other fields.

    Icon = UNICHAR(11044)

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI Anonymous ,

You can add a calculated column with unichar function to display symbol icon, then you can enable conditional formatting on it to display different color based on other fields.

Icon = UNICHAR(11044)

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks a Lot,

    Worked fine. As I had 3 possible values (0=Black, 1=Green; 2=Red), a lot of KPIs (Rows) and 12 Months(columns), what I did was to convert the text columns to number, then I created another 12 month columns = Unichar (11044) and then I created a Table Visual and applied for each new icon month_column the following steps:

     

     

     

    Thanks a lot :)