Replace text with unichar to text with icon

[Anonymous]

Hello,

In Power BI you can add icons with the UNICHAR codes.

This you can do by creating a new measure or new columns.

But in our case we have a text string in our data warehouse with the UNICHAR code, so we want to display it directly with text & icon. Now it shows up as text instead.

Can anybody help me to replace the test as icon?

Thanks!

Davina

[Anonymous · Accepted solution]

Found a solution, we created chr in the pyspark codes so Power BI need only to get the data and show immediatly without any other calculation in the reports.

Thanks for the tips!

[Anonymous]

Hi  @Anonymous ,

Here are the steps you can follow：

1. Create measure.

Flag =
IF(
    ISERROR(
       SEARCH("UNICHAR", MAX('Table'[Example]))
    ),
    1,
 SUBSTITUTE (
        SUBSTITUTE (MAX('Table'[Example]),"UNICHAR(128100)",UNICHAR(128515) ),
        "UNICHAR(128197)",
        UNICHAR(128515)
    )  
)

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

@Samarth_18 thanks for you suggestion.

But I have a whole string in the backend with more information and multiple UNICHAR codes, so every code should show the icon. Is that possible?

Example text:

" UNICHAR(128197) 19/04/2022 This article is recently made UNICHAR(128100) authorname "

We can add them togheter in the Power BI dashboard itself, but we work with a directQuery connection and thought this will be quicker to show.

kind regards,

Davina

[Samarth_18]

Hi @Anonymous ,

In my understanding you still need a column only in your table with below code:-

Unicode_Convert = IFERROR(UNICHAR('Table'[Unicode column]), "Not Supported")

Thanks,

Samarth