Home ยป Unichar function DAX

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 TutorialSQL Advance TutorialSSRSInterview Q & A
SQL Create tableSQL Server Stored ProcedureCreate a New SSRS Project List Of SQL Server basics to Advance Level Interview Q & A
SQL ALTER TABLESQL Server MergeCreate a Shared Data Source in SSRSSQL Server Question & Answer Quiz
SQL DropSQL Server PivotCreate a SSRS Tabular Report / Detail Report
..... More.... More....More
Power BI TutorialAzure TutorialPython TutorialSQL Server Tips & Tricks
Download and Install Power BI DesktopCreate an Azure storage accountLearn Python & ML Step by stepEnable Dark theme in SQL Server Management studio
Connect Power BI to SQL ServerUpload files to Azure storage containerSQL Server Template Explorer
Create Report ToolTip Pages in Power BICreate Azure SQL Database ServerDisplaying line numbers in Query Editor Window
....More....More....More




 1,776 total views,  4 views today

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.