Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
VoltesDev
Helper V
Helper V

DIsplay string value as icon

Hi,

 

How to display string value as icon wihtout the need to create new field ? In my table, I have data with value of "neutral / positive / negative" . While I still want to display the original text, I also want to display as an icon. 

I know there is Conditional Formatting to do this, but if I add again the same field, so there will be 2 same fields. After I set conditional formatting of the 2nd field to display as icon, the other also changed.

 

May I know how to achieve this ? original text and the one with display as icon side by side in a table.

Thanks

1 ACCEPTED SOLUTION

I see in that case you can use unicode characters.

ajohnso2_0-1718986282081.png

 

SentimentIcon = 
VAR _SelectedSentiment = MAX(Sentiment[Sentiment])
RETURN
SWITCH(
    TRUE(),
    _SelectedSentiment = "Positive", UNICHAR(128578),
    _SelectedSentiment = "Negative", UNICHAR(128545),
    _SelectedSentiment = "Neutral", UNICHAR(128528)
)

 

View solution in original post

4 REPLIES 4
ajohnso2
Resolver II
Resolver II

Are you referring to clickable buttons?

 

ajohnso2_0-1718983053196.png

I have achieved this by using the new Slicer visual no fancy tricks.

 

You could also create something like below by creating a static table in power query and creating some icons with SVG's.

 

ajohnso2_1-1718983218440.png

Also using the new slicer visual

Hi,

 

No, I mean inside a table. Something like this :

VoltesDev_0-1718985000262.png

Thanks

I see in that case you can use unicode characters.

ajohnso2_0-1718986282081.png

 

SentimentIcon = 
VAR _SelectedSentiment = MAX(Sentiment[Sentiment])
RETURN
SWITCH(
    TRUE(),
    _SelectedSentiment = "Positive", UNICHAR(128578),
    _SelectedSentiment = "Negative", UNICHAR(128545),
    _SelectedSentiment = "Neutral", UNICHAR(128528)
)

 

Thank you.

 

It also means we have to create new measure, then. 😉

 

Thanks again.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.