topic Re: enhanced scatter plot - dynamic backdrop image in Developer

enhanced scatter plot - dynamic backdrop image

AnnL — Fri, 14 Jul 2017 18:19:57 GMT

The short tutorial for the enhanced scatter plot visual shows that it can be configured to dynamically change the backdrop image using an image measure and a slicer. The details of how to do this are not included. Can someone provide the DAX for the image measure, a view of the corresponding data structure, etc.

Thanks,

AnnL

Re: enhanced scatter plot - dynamic backdrop image

Eric_Zhang — Mon, 17 Jul 2017 07:45:28 GMT

@AnnL wrote:

The short tutorial for the enhanced scatter plot visual shows that it can be configured to dynamically change the backdrop image using an image measure and a slicer. The details of how to do this are not included. Can someone provide the DAX for the image measure, a view of the corresponding data structure, etc.

Thanks,

AnnL

@AnnL

Based on my test, the dropback field doesn't accept any DAX measure but a table column. One issue I've found in my test is that, if no silcer/filter applied, the dropback seems showing the first image in alphabetical Order, I can't use an DAX measure to overcome this issue, as the field doesn't accpet any measure. So you may have to set any filter by default for the visual to expect it to show the backgroud properly. See more in the attached pbix file.

Issue

Re: enhanced scatter plot - dynamic backdrop image

AnnL — Mon, 17 Jul 2017 19:02:58 GMT

Hi Eric,

I downloaded your Power BI file and I think I understand what you did. However, when I tried to extend it to a more complex data set, I cannot get the images to appear. In my data model, I have x and y position data that overlays the image (as in the tutorial), and the data item that switches the image is one of two filters. The filters both work for selecting the data subsets but the corresponding image for the subset does not show.

Not sure how to attach the pbix file I have been experimenting with. Can I upload the file so that you can take a look for any reason why the images do not work?

Thanks very much,

AnnL

Re: enhanced scatter plot - dynamic backdrop image

v-viig — Tue, 18 Jul 2017 11:51:51 GMT

Please upload your .pbix file to any cloud such as One Drive.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: enhanced scatter plot - dynamic backdrop image

AnnL — Tue, 18 Jul 2017 19:56:04 GMT

Hi Eric_Zhang,

I did finally get it working based on your example. Thanks very much.

One sticking point I had is that it does not appear to work with images in a local file folder. It only works with images located at a URL.

Also, it seems to have a limit in the URL length. My attempt using the URLs of the images posted to my local SharePoint did not work and I expect it is because the path is very long.

So it worked when I pointed to images out on the web that have short paths, as you had in your example.

Thank you very much,

Ann

Re: enhanced scatter plot - dynamic backdrop image

AnnL — Tue, 18 Jul 2017 20:00:08 GMT

Hi Ignat,

I did get it working using the method in the example from Eric.

I found limitations - that the images must be pointed to by a URL not a network drive location, and that the URL to the image cannot be too long.

Is there a way to remove these limitations? For example, if the URL could be arbitrarily long, then I could post the images we want to use on the internal SharePoint. Currently the path to any image in our SharePoint is too long.

Thank you for your help,

AnnL

Re: enhanced scatter plot - dynamic backdrop image

v-viig — Wed, 19 Jul 2017 08:44:01 GMT

As far as I know, there's no limitation for link.

Can you share a link if it isn't private?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: enhanced scatter plot - dynamic backdrop image

AnnL — Thu, 20 Jul 2017 17:33:09 GMT

Hi Ignat,

The link is private. If you want to test, any link with over 260 characters should do.

Regards,

AnnL

Re: enhanced scatter plot - dynamic backdrop image

v-viig — Fri, 21 Jul 2017 08:49:14 GMT

We'll look into this issue.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: enhanced scatter plot - dynamic backdrop image

Sanjiv — Thu, 03 Aug 2017 01:35:17 GMT

Hi,

I have my images stored in local drive. How can i access it using http URL ? I tried placing it in sharepoint but it won't work, not sure its because of security or length of the url.

Regards,

Sanjiv

Re: enhanced scatter plot - dynamic backdrop image

v-viig — Thu, 03 Aug 2017 08:31:34 GMT

Enhanced Scatter Chart doesn't support hyperlinks that require authentication.

You should make your hyperlinks public and use them with the visual.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: enhanced scatter plot - dynamic backdrop image

AnnL — Thu, 03 Aug 2017 18:18:34 GMT

Hi V-Viig,

The original scatter chart allows use of an image background with the image located on a local network drive. The fact that the enhanced scatter plot only allows images located at hyperlinks that do not require authentication means that the enhanced scatter plot background image feature is NOT usable in an internal corporate environment.

Is there any way we can get a fix for the enhanced scatter plot so it will allow using images from a local network drive as the original scatter chart does?

Regards,

AnnL

Toyota Manufacturing NA

Re: enhanced scatter plot - dynamic backdrop image

AnnL — Thu, 03 Aug 2017 18:23:16 GMT

Hi V-Viig,

It turns out that using a web server internally does work. So that is our solution for now.

Regards,

Ann

Re: enhanced scatter plot - dynamic backdrop image

v-viig — Fri, 04 Aug 2017 06:54:21 GMT

Thanks for sharing your solution.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com