Show image by slicer

[twmy0]

Hi All,

I have a report that shows different projects with corresponding history, i.e. I have project 1-8, for project 1, I have all version in latest 1 year from Jan 2024 to Dec 2024, same for project 2 to project 8.

For each project & period selection, like project 1 in Feb 2024, there'll have around 25 pages include data, narrative and ideally image, the report format was the same among all.

All tables (normally 1 section in 1 table) link with 2 dimension tables, Project, and Calendar (in Year Month), so that corresponding data will be retrive.  A slicer (chicklet slicer) was used in landing page and sync with other page so user can select which project and period report they wanna see as a control.

Issue: I want to show images (~15 images per report) dynamically in entire report when both report & period was chose by user.  Some image was big and was the cover of entire subpage, some are smaller with only half or 1/4 page.  Please note display the image as icon in tables was not a solution for me coz image was part of report instead of icon.

Try: 

- Change image link in base 64 and store in excel, with additional column include Yearmonth, project, section, unique image name. Upload to data model.  When relationship between both Calendar and Project tables were connected, no image can be shown (I use Image pro custom visual).  When no relationship was created, I can see the data but only show a very small top portion of image.

- Can change image to HTML code and show by HTML 5 custom visual (in desktop), but only PBI certify visual can show in server.  HTML (lite version) seems can't show image.

Thanks a lot for your help. 

[lbendlin · Accepted solution]

If your Base64 text is longer than 32K then you need to store it in chunks, and later stitch it back together.

https://blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/

[danextian · Accepted solution]

Hi @twmy0 

The Power Query engine can load text values up to a maximum of 32,766 characters into a single cell in a table. Text exceeding this limit will be silently truncated. Even if you use html viz but still refering to a base64 column, the image will still be truncated. Resize the image by either changing the resolution  or doing some loseless compression using websites like tinypng.com and then reconvert them back to base64.

[lbendlin · Accepted solution]

If your Base64 text is longer than 32K then you need to store it in chunks, and later stitch it back together.

https://blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/