Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Display photos in Matrix

Hi All,

 

I would greatly appreciate some help on this issue!

 

I need to create multiple Photo Reports. However I cannot display Images with 'MATRIX' visuals. MATRIX visuals only display links (see below screenshot)...

 

Matrix visual.PNG

 

It works fine when I use 'TABLE' visual (see below screenshot).

 

Table visual.PNG

 

However, I need photos to display on the 'MATRIX' visual as I need to pivot the data... 

 

Here is what I do:

 

1. In my SQL query I add:

CONCAT('http://smausiviewer.azurewebsites.net/LoadImage.ashx?Database=Plexice_Australia&Filename=', IMAGE ,'&Large=1')

2. In Power Bi 'MODELLING' tab > I choose Data Category: Image URL

 

Is there something else I can do for my Photos to display on the 'MATRIX' visual?!

Here is my PBI file if you want to play around with the data:
Photo Report Link

 

Thanks in advance for your help.

Robin

8 REPLIES 8
Jatinsha
New Member

  • Jatin Sharma 
Anonymous
Not applicable

Anyone else would know a solution for this?

Hi @Anonymous,

The solution @prateekraina post is a great one by using the feature of Power BI. And puting a text column in VALUES feild is unsupported.

Best Regards,
Angelia

prateekraina
Memorable Member
Memorable Member

Hi @Anonymous,

 

I just tried this at my end with some of my data. It works fine in Matrix. Here is the screenshot:

Capture.PNG

 

Can you share what have you kept on rows and what on columns & values?

The pbix file which you have shared is not accessible also, so did not have a look at it.

 

Prateek Raina

Anonymous
Not applicable

@prateekraina sorry about the link, I hope this one works:

Photo Report Link

 

Hi @Anonymous,

Here is the solution:

 

1. Place all the fields in the Rows section.

     Capture.PNG

 

2. Go to Format pane > Row Headers, Turn Stepped Layout to OFF.

    Capture.PNG

 

3. Now drill to the lowest level of data by clikcing on below button twice till you reach end of the hierarchy.

    Capture1.PNG

 

4. Bingo !! You now have the desired view of images in matrix.

 

    Capture2.PNG

 

Please mark my answer as solution and hit thumbs up if you think i have solved your query.

 

Prateek Raina

Anonymous
Not applicable

Hi @prateekraina,

 

Thanks for your input. However, isn't your solution the same as using a 'TABLE' visual?

 

As I said, I need to pivot the data to have better display options for my clients.

 

So, one of my fields need to go into the COLUMNS section and my IMAGE LINK need to be in the "VALUES" section (such as below).

 

Fields.PNG

 

Do you think this can be done?

 

Cheers

Robin

 

 

Hi @Anonymous,

 

You should not put a text column in VALUES feild as it is meant for only fact value / numbers.

Image Link column is a Text column at end of the day so it makes no sense to put it in VALUES.

 

You need to rethink about your matrix design.

 

Prateek Raina

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.