Custom Shapes in PowerBI

[abhishek_2593]

I am using an excel data for my dashboard, i am using custom shape in excel for certain fiels like Rating - 1 star, 2 star, 3 star etc., but when i load the same sheet to PowerBI, i am unable to get these shapes but instead get text in its place.
How do i retain the shape in PowerBI?

Can someone please help.

In excel - 

In PowerBI - 

[v-henryk-mstf · Accepted solution]

Hi @abhishek_2593 ,

You can use UNICHAR in powerbi to customize the icons. Refer to the following test results.

love star =
REPT ( UNICHAR ( 9733 ), 6 - MAX ( 'Test'[Love] ) )
    & REPT ( UNICHAR ( 9734 ), MAX ( 'Test'[Love] ) )

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NickolajJessen]

I don't know much about special characters like this.

In a case like this, i would usually reference pictures in stead.

1	*Link to 1 start picture*
2	*Link to 2 start picture*
3	*Link to 3 start picture*

Good video:
https://www.youtube.com/watch?v=hGKykytzLXs