Add Star Rating In Power BI Desktop Using DAX Expression

Overview

In this article, we will learn how we can add Star Ratings in Power BI desktop using a DAX Expression.

I have attached a sample practice file with this article.


Scenario

I have one Product table having two columns:

  • Product Name

  • Rating















Now, I want to represent ratings in the form of Stars.

Let’s get started.


Step 1

Create a new measure column in Power BI Desktop.


Step 2

Add the following DAX expression.

  1. Star Rating =  

  2. REPT(UNICHAR(9733), AVERAGE('Product'[Rating]))  

  3. &  

  4. REPT(UNICHAR(973