How to use Emoji’s emotions on Power BI?

Emojis are frequently used when creating a sales report.In other reports, emojis are often used to express the situation on cards and tables.There are multiple ways to add emojis.

Method 1:

Press Windows Key + Period. If you’re using Windows 10, a dialog box will pop up showing all the possible emojis to choose from. You can also search for emojis that suit your needs by pressing the magnifying glass icon at the bottom left.

Method 2:

You can copy emojis from the web and paste them directly into the Power BI formula bar.

Method 3:

Use the UNICHAR function. This is a built-in DAX function that takes single-character numeric codes and converts them to their visual representation. You can give a number to the UNICHAR function and get your emojis that way.

Example

As an example, I used cards in the sales report and reflected emojis in these cards. The sales performance was classified as very good, good, bad, very bad, dispersed between the values ​​I specified.

Icons =
SWITCH (
TRUE (),
SUM ( Sayfa1[Satış Tutarı] ) < 350000000, “😣 Very Bad”,
SUM ( Sayfa1[Satış Tutarı] ) < 600000000, “😏 Bad”,
SUM ( Sayfa1[Satış Tutarı] ) < 1000000000, “😀 Good”,
“😍 Very Good”
)

We come to the sales amount column and add the emoji measure we created to the sales amount column with conditional formatting.

After the process is complete, when you click on any column or filter something, the emoji will dynamically change according to the given expressions.

The emoji changed to bad because the sales of the selected city were lower than the specified number.

In high-selling places, the emoji changed dynamically.

This way you can dynamically use emojis in your Power BI reports. I hope I could help :)