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 ...
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.

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.