Adding icons/images to matrix

[boostdb]

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.

[v-zhengdxu-msft · Accepted solution]

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]

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

[speedramps]

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

[speedramps]

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

[boostdb]

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