Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Custom Shapes in PowerBI

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 - 

 

Need Help
Tips and Tricks
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi Anonymous ,

     

    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.

2 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    Hi Anonymous ,

     

    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.