Create a clustered bar chart with icon y axis in Power BI

[mahnazhghighi]

Hi. I have a hotel dataset and it has a column named 'Review Rating' that its values is numbers 1 to 5(for its stars). I want to create a clustered bar chart in Power BI that its y axis is shown with stars. for example for Review Rating 1 shows one star and for Revie Rating of 3 shows three stars. Can you help me?

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Customer count = 
COUNTROWS(rating)

Customer count all = 
CALCULATE([Customer count], REMOVEFILTERS('description'))

percentage = 
DIVIDE([Customer count], [Customer count all])

[Kedar_Pande]

@mahnazhghighi 

Create a Calculated Column:

StarRating = REPT("★", [Review Rating])

Drag the new StarRating column to the Y-Axis of your clustered bar chart.
Add your measure (e.g., count of reviews) to the X-Axis.

Ensure that your StarRating column is sorted by the numeric Review Rating to keep the stars in the correct order.

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[mahnazhghighi · Accepted solution]

thanks for your answer. I used the below Formula and it worked:

Star Rating = SWITCH(

     'Icon Rating'[ID],

     1,UNICHAR(11088),

     2,UNICHAR(11088)&UNICHAR(11088),

     3,UNICHAR(11088)&UNICHAR(11088)&UNICHAR(11088),

     4,UNICHAR(11088)&UNICHAR(11088)&UNICHAR(11088)&UNICHAR(11088),

     5,UNICHAR(11088)&UNICHAR(11088)&UNICHAR(11088)&UNICHAR(11088)&UNICHAR(11088)

     )

[tharunkumarRTK]

@mahnazhghighi 

There are many ways to achieve this, one easiest way is to use ★ unichars. 

I have attached the pbix for your reference 

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Customer count = 
COUNTROWS(rating)

Customer count all = 
CALCULATE([Customer count], REMOVEFILTERS('description'))

percentage = 
DIVIDE([Customer count], [Customer count all])

[mahnazhghighi]

thank you. I did it,but now I dont know how to convert * to animated star.

[tharunkumarRTK]

@mahnazhghighi 

⭐

you can copy from here:

https://www.namecheap.com/visual/font-generator/star-symbols/

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[mahnazhghighi]

thank you. i do that , but i dont know how convert * to animated star.