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.  
Need Help
  • 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.

     

     

     

     

boostdb's avatar
boostdb
New Member
2 years ago

Thanks! Is it possible to add img/jpeg/png instead of icon?

speedramps's avatar
speedramps
Icon for Super User rankSuper User
2 years ago

boostdb there is no option I know of to add am image to a standard visual header.
There may be a custom visual that does it.

However, you can display images in a body cell of a visual.
So you could have an image on the top row cells after the heading.

But the user might sort the columns.
Learn how to display images in the body of a visual here
https://www.youtube.com/watch?v=hGKykytzLXs 

You can also add data visual (eg table or graph).

Then add a static image visuals and drag and resize them over the data visual.
Then group the visual together.

 

The users will think that it is one visual, but it is actually a grou of images on top of a data visual.

Learn how to group objcets here

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-visuals

 

Please be polite and quickly click the "accept as solution" button.
Remember we are unpaid volunteers giving you free expert help,
and you may need help again. Thank you.