What is UNICHAR in Power BI?

Ever look at a Power BI report and wish you could add simple icons like up/down arrows, star ratings, or status indicators directly into your tables and visuals? You can, and it's easier than you might think. This article will show you how to use the powerful yet simple DAX function UNICHAR to bring your reports to a new level of visual clarity.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly is the UNICHAR Function?

In simple terms, the UNICHAR function in Power BI is a tool that translates a number into a specific character or symbol. Every font on your computer has a standardized list of characters, and each character is assigned a unique number. This standard is called Unicode.

Think of it like a secret decoder ring for your reports. You provide the UNICHAR function with a specific numeric code, and it returns the corresponding symbol. This allows you to insert everything from simple checkmarks (✔) and arrows (▲) to more complex emojis (🟢) directly into your DAX formulas.

This is incredibly useful for creating more intuitive reports. Instead of just displaying the words "high," "medium," or "low," you can show colored circles. Instead of displaying a customer rating of "4," you can show four filled stars. These visual cues help your audience understand the data at a glance, making your reports more effective and engaging.

Finding the Right Unicode Number

Before you can start adding symbols, you need to find their corresponding numeric codes. The UNICHAR function uses decimal codes, so it's important to find the right number for the symbol you want.

Here are a few easy ways to find them:

• Unicode Websites: Websites like unicode-table.com are excellent resources. You can search for a character (e.g., "star" or "arrow") and find its information. Be sure to look for the decimal code (often labeled as "Decimal" or "Dec").
• Windows Character Map: If you're on a Windows computer, you have a built-in tool called Character Map. Just search for it in your Start Menu. You can browse through fonts, click on a symbol, and see its Unicode code at the bottom of the window (e.g., U+25B2). You need to convert this hexadecimal code (25B2) to a decimal number (9650) to use it in DAX, which you can do with a quick online search for a "hex to decimal converter."

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

A Shortlist of Popular Codes

To get you started, here is a list of commonly used numbers for the UNICHAR function:

• Up Arrow (▲): UNICHAR(9650)
• Down Arrow (▼): UNICHAR(9660)
• Right Arrow (►): UNICHAR(9658)
• Left Arrow (◄): UNICHAR(9668)
• Solid Star (★): UNICHAR(9733)
• Outline Star (☆): UNICHAR(9734)
• Check Mark (✔): UNICHAR(10004)
• X Mark (✖): UNICHAR(10006)
• Green Circle (🟢): UNICHAR(128994)
• Yellow Circle (🟡): UNICHAR(128993)
• Red Circle (🔴): UNICHAR(128992)

Practical Examples: Using UNICHAR in Your Reports

The best way to understand UNICHAR is to see it in action. Let's walk through some common scenarios where this function can make a huge impact on your report's usability. For these examples, let's assume you have a basic sales table.

Example 1: KPI Indicators with Up/Down Arrows

Imagine you have a sales table and you want to quickly show whether the sales for a particular transaction were above or below the average sale amount. A simple up or down arrow next to the sales figure is perfect for this.

You can create a new calculated column in your table with a DAX formula that uses an IF statement.

Scenario: Show an up arrow if sales are greater than $200, and a down arrow if they are not.

The DAX Formula:

Sales Trend = IF(Sales[Sales Amount] > 200, UNICHAR(9650), UNICHAR(9660))

When you add this "Sales Trend" column to your table visual, you'll see an arrow next to each row, immediately indicating its performance against the target.

Taking it a step further with conditional formatting: You can make this even better by coloring the arrows. Select your table visual, go to the Format pane, find "Cell elements," select your "Sales Trend" column, and turn on "Font color." You can add rules to make the up arrow green and the down arrow red, adding another layer of instant visual feedback.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Example 2: Creating Star Ratings for Products or Services

Let's say your dataset includes product ratings on a scale of 1 to 5. Instead of just showing the number, you can create a familiar five-star rating visual.

This requires combining UNICHAR with another handy DAX function, REPT, which repeats a text string a specified number of times.

Scenario: You have a "Rating" column with a whole number from 1 to 5. You want to display this as a star rating.

The DAX Formula:

Star Rating = REPT(UNICHAR(9733), Sales[Rating]) & REPT(UNICHAR(9734), 5 - Sales[Rating])

Breaking Down the Formula:

• REPT(UNICHAR(9733), Sales[Rating]) takes the solid star symbol (★) and repeats it based on the number in your [Rating] column.
• REPT(UNICHAR(9734), 5 - Sales[Rating]) takes the outline star (☆) and repeats it for the remainder. So, if the rating is 3, it will add 2 outline stars.
• The & operator concatenates (joins) these two parts together.

The result is a dynamic and intuitive rating system. A rating of 4 will appear as "★★★★☆".

Example 3: Status Indicators (Traffic Lights)

Traffic light systems (red, yellow, green) are universally understood symbols for status. This is perfect for project management dashboards, inventory level tracking, or any scenario where you have defined statuses.

For this, the SWITCH function is often cleaner than a series of nested IF statements.

Scenario: You have a project table with a "Status" column that contains text values like "Completed," "In Progress," or "Delayed."

The DAX Formula:

Project Status Icon = SWITCH( TRUE(), 'Projects'[Status] = "Completed", UNICHAR(128994), -- Green Circle 'Projects'[Status] = "In Progress", UNICHAR(128993), -- Yellow Circle 'Projects'[Status] = "Delayed", UNICHAR(128992), -- Red Circle UNICHAR(11093) -- Default to a white circle if status is different )

This formula checks the value in the "Status" column and returns the corresponding colored circle. It's a clean way to transform text-based status updates into something much faster to interpret.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Example 4: Building More Informative Column Labels

You aren't limited to using UNICHAR on its own. You can combine it with text to create richer, more descriptive columns in your tables and matrices.

Scenario: Display a task's completion status with both text and a symbol for quick confirmation.

The DAX Formula:

Full Status = "Status: " & IF([Task Complete] = TRUE, "Complete " & UNICHAR(10004), "Pending")

This will produce results like "Status: Complete ✔" or "Status: Pending," giving you the best of both worlds: a clear text description and a confirming visual icon.

Best Practices for Using UNICHAR

• Keep It Simple: The goal of using icons is to improve clarity, not to decorate your report. Too many symbols can create visual clutter and make the report harder to read. Use them purposefully to highlight key data points.
• Consider Your Audience and Accessibility: While a green circle for "good" is widely understood, some symbols might be ambiguous. Ensure your symbols have clear meanings, and consider adding a legend if needed. Not all users may see colors, so the shape of the symbol should also convey meaning (e.g., up arrow vs. down arrow).
• Test for Compatibility: While most standard Unicode characters work perfectly everywhere, some very obscure or brand new emojis might not render correctly on all devices or when exporting to PDF. It's always a good idea to stick to commonly used symbols to ensure consistency.

Final Thoughts

The UNICHAR function is a simple but incredibly effective tool in any Power BI developer's toolkit. By translating numeric codes into visual symbols, it allows you to make your reports more intuitive, engaging, and professional without a steep learning curve. The examples above are just the beginning - once you start using it, you'll find countless ways to enhance your data storytelling.

While mastering specific DAX functions is a fantastic way to improve your reports, the process of manually building dashboards, especially from multiple data sources, can still be time-consuming. We built Graphed because we believe getting insights shouldn't require complex setups or an expert-level understanding of every function. After connecting your sources in seconds, you can just ask questions in plain English, like "Show me a dashboard of Shopify sales vs Facebook Ad spend by campaign," and we'll create the dashboard for you automatically, keeping it updated in real-time.