Forum Discussion

ahmedshalabyy12's avatar
5 months ago
Solved

Table Highlight in Desktop

Hello, How can I do a highlight like this in table?  
  • Irwan's avatar
    5 months ago

    hello ahmedshalabyy12 

     

    Natarajan_M is straightforward which you can try it first.

    as pcoley said, this should be possible by using svg.

     

    however, this is a workaround if you want to have those customized icon instead of font and background color as explained by Natarajan_M and without using SVG as explained by pcoley .

    1. put all your customized image icon in a folder (you can do a local folder).

    2. import those image to power bi (get data->folder). then define the image which for what condition.

    3. transform that image into base64

    = Table.AddColumn(#"Removed Other Columns", "Custom", each "data:image/png;base64, " & Binary.ToText([Content], BinaryEncoding.Base64))

    4. import to power bi

    5. create a calculated column to calculate the base64 code based on your fact table condition and DONT forget to change data category into Image URL.

    Image =
    MAXX(
        FILTER(
            'IMG',
            'Table'[Promo Tier]='IMG'[Condition]
        ),
        'IMG'[Custom]
    )
    6. plot into table visual

     

    Hope this will help.

    Thank you.