How to show Rating Stars and Traffic Light Indicators in Power-BI


Description: In most of the scenarios we need to visualize the Data (Performances) with Rating Stars or Traffic light indicators.  

                  Following are the steps illustrating the performance indicators in Power-BI reports.

Source:

     

Step 1:


        As per the data our requirement, the stars in a new column based on the rating column. So we need to write a measure with Unichar codes. Please follow the below measure for stars rating.

Measure: 
Stars =
REPT(UNICHAR(9733), AVERAGE('Sheet1'[Rating ]))      &
REPT(UNICHAR(9734), 5-AVERAGE('Sheet1'[Rating ]))

 Output:

   



Step 2:

      Now we can write two more measure with unichar codes based on the same rating column.

Measure 1:

     Mensymbol =
REPT (UNICHAR (128697), AVERAGE ('Sheet1'[Rating]))

Output:


Measure 2:

Lights =
REPT(UNICHAR(11044), AVERAGE('Sheet1'[Rating ]))

Output:

             

Note: Use conditional formatting on lights measure for requiring colour conditions.

Thank you.


Comments

Popular posts from this blog

Changing the X and Y axis values based on Slicer Selections in Power-BI

Hide /Unhide the Slicer Panel in Power-BI