Forum Discussion

boostdb's avatar
boostdb
New Member
2 years ago
Solved

Adding icons/images to matrix

Hi,   Is this possible? 1. First sum of all rows from table to PBI matrix.  2. Add icons/images to the label and text or only icons/images.  
  • Anonymous's avatar
    Anonymous
    2 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.