Unichar function DAX

UNICHAR function is a power BI DAX text function that returns Unicode character referenced by the numeric value.

 

DAX Syntax

UNICHAR(number)

number is a unicode number that represents the character, and returns an error, number is zero.

Lets look at an example of UNICHAR function

The following DAX measure RedColor returns the character represented by the Unicode number 128992 that is red color circle character.

RedColor = UNICHAR(128992)

 

Lets drag the measure to the card visual to see the output.

Lets look at an another example using dataset.

Here we have a sample dataset named Customerfeedback.

Which contains the customer names along with the ratings (out of 5) given by them for restaurant service.

Lets display the ratings in terms of visual like if customer has given 2 rating then display two star, if 5 then 5 star.

Following Dax measure uses the Dax function REPT, that repeats text a given number of times , for text we provide a UNICHAR Code number 11088 that returns the yellow star character.

Ratings = REPT(UNICHAR(11088), AVERAGE(CutomerFeedback[ServiceFeedback]) )

Lets use matrix visual to display the Customer and ratings given by them.

You can also use another unicode character to make your visual more interactive, You can get various unicode character symbol from website – URL

SQL Basics Tutorial	SQL Advance Tutorial	SSRS	Interview Q & A
SQL Create table	SQL Server Stored Procedure	Create a New SSRS Project	List Of SQL Server basics to Advance Level Interview Q & A
SQL ALTER TABLE	SQL Server Merge	Create a Shared Data Source in SSRS	SQL Server Question & Answer Quiz
SQL Drop	SQL Server Pivot	Create a SSRS Tabular Report / Detail Report
..... More	.... More	....More
Power BI Tutorial	Azure Tutorial	Python Tutorial	SQL Server Tips & Tricks
Download and Install Power BI Desktop	Create an Azure storage account	Learn Python & ML Step by step	Enable Dark theme in SQL Server Management studio
Connect Power BI to SQL Server	Upload files to Azure storage container		SQL Server Template Explorer
Create Report ToolTip Pages in Power BI	Create Azure SQL Database Server		Displaying line numbers in Query Editor Window
....More	....More		....More

 4,626 total views,  1 views today