Forum Discussion
Adding icons/images to matrix
- Anonymous2 years ago
Hi boostdb
Please try this:
I create a sample data:
Then create a new table with this dax:
Table 3 = ADDCOLUMNS( VALUES('Table (3)'[Column1]), "Icon", SWITCH( 'Table (3)'[Column1], "Col1", UNICHAR(128643) & "Col1", "Col2", UNICHAR(128644) & "Col2", "Col3", UNICHAR(128645) & "Col3" ) )The next step is to create both relationship between two table:
The result is as follow:
Link of unichar function:
UNICHAR function (DAX) - DAX | Microsoft Learn
The unicode of emoji:
Emoji unicode characters for use on the web (timwhitlock.info)
You need to transform the hex to dec:
Best Regards,
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Try this ...
Click here to download PBIX from OneDrive
How it works
Drag the filed to the visula Column well.
Then click on te column well and press the Windows + ; keys
to display the emoji screen
Just to be clear press the Windows key and the Plus key and the Semicolon key simultaneously
Please click thumbs up and accept as solution buttons
Thanks! Is it possible to add img/jpeg/png instead of icon?