Dynamic images displayed based on Business Central Sales Orders

[SteadyOne]

Hello all - 

I'm relatively new to Power BI and encountering a 'how to' situation which I cannot find an answer to.  

I have a sales department who require that an image of the project be included on the report.  Each order will have a unique image, there are no repeats.  It would be easy for me to simply add the image from the desktop application....but from what I've been reading accomplishing this as an end user from a published report may be very difficult bordering on impossible.  

My current line of thinking is to find some way to write a dynamic URL referring to the image files on a shared space - likely One Drive - and then having that dynamic URL tied to the sales order number.  The URL would then reference the file with a name which uses the sales order.

How does one write a dynamic URL in Power BI?

Of course, I am open to any other suggested methods.

[Anonymous · Accepted solution]

Hi, @SteadyOne

Based on the information you have provided, Here are my answers to your questions.

You can create a New Calculate Column, if your OneDrive URL is https://onedrive.live.com/  and your image file name is 'Table'[Name].png , then the calculated column formula would be Image URL = https://onedrive.live.com/ & [Sales Order Number] & ".png".

When you change the Image URL, it will change to the result you need.

You also can see this document for a further study: Dynamic embedded URLs in Power BI (datapears.com)

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PijushRoy]

HI @SteadyOne 

Please add page-level tooltip and then add dynamic image in the tooltip page.
How to create Tooltop page - https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips?tabs=powerbi-desktop

I hope you have a column for URL
Use this URL in the Image visual on the tooltip page. It will work line dynamic image
Take free image visual from Power BI Custom Visual source
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104381835?tab=overview

Like this, when users mouse over on Order, can see the image

If your requirement is solved, please make sure to MARK AS SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
www.MyAccountingTricks.com 
https://www.youtube.com/MyAccountingTricks

[SteadyOne]

I appreciate the response - however this doesn't solve my problem.  This solution would require a prebuilt column of URLS....and I need to generate the URL based images which don't exist yet, but will when the new order is placed.

[PijushRoy]

Hi @SteadyOne 

I am not sure I understood your question correctly
You mean in your present table, there are no columns for URL
What is the process to generate URL
Can you please share sample data structure or screenshot (hide sensitive info)