Forum Discussion

robbert-bi's avatar
robbert-bi
Icon for Helper I rankHelper I
1 year ago

How to create extra icons (yellow traffic light)?

Hi all. I would like to create extra icons which I can use in conditional formatting in a table. I currently have a pivot with an orange, red, grey and green traffic light. These come from the standa...
Need Help
robbert-bi's avatar
robbert-bi
Icon for Helper I rankHelper I
1 year ago

Hi. Thanks, but this works with measures. I need to have icons in a simple text column and based on the value in the text column the icon should have a specific color.

  • v-menakakota's avatar
    v-menakakota
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi robbert-bi ,
    Thanks for reaching out to the Microsoft fabric community forum. 

    Since Power BI doesn't let us change the built-in icon colors for text columns, here's a simple workaround you can try:

     

    create a new column that shows the image URL based on the text value:

    TrafficLight =
    SWITCH(
    [Status],
    "Red", "https://yourlink.com/red.png",
    "Orange", "https://yourlink.com/orange.png",
    "Yellow", "https://yourlink.com/yellow.png",
    "Green", "https://yourlink.com/green.png"
    )

    Select the column, then go to the Model view, and set Data Category to Image URL.
    Add that column to your table now your traffic lights will show up with the correct colors.

    Best Regards, 
    Menaka.
    Community Support Team