Scatter plot data labels with x,y values

[DAX_merchant]

Hello,

I have a scatter plot in Power BI. For context, this plot takes two measures, one for each axis. The measures represent sales for a certain time period per store (store field is in the legend)

The purpose of this graph is to show how each store does by comparing it to itself at a different time period. I have two slicers, one for the x axis and one for the y axis which filters by date, giving me total sales for each store for the selected time period. 

I want the data label to show me the x, y coordinates of my point, but can't figure out how to do this. Category labels just pulls the legend. Furthermore, I can't add a measure into the values section of the scatter plot. Any help would be appreciated!

[lbendlin]

should be doable.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[DAX_merchant]

Sample file can be found here:

https://www.dropbox.com/scl/fi/lue5xfwur69tgenhe93w6/Scatter-sample.pbix?rlkey=kzt9bpw3gxsvpzzlj4mwm...

The goal is for the data labels to not be A, B, C but the x, y coordinates 

[lbendlin]

You may want to consider different visualizations. For example a ribbon chart

or a scatter plot/tornado chart a la Hans Rosling that shows both the current sales and the YoY trend per store - over time

Now for the bad news - the data labels can only ever be columns, not measures.

[DAX_merchant]

Unfortunately, I am only interested in the scatter. 

Do you have any experience with Deneb / do you know if something simple like this is possible with that custom visual? 

[lbendlin · Accepted solution]

Sure, Deneb is an option. Note that Deneb won't be able to tell measures from columns so you will have to provide all the necessary data points into the dataframe.

[DAX_merchant]

This is great, thank you. Any idea if Deneb has a feature that allows the labels to be intelligently placed as to not overlap? Or a way to match the label text color to the legend color?

I am very new to Deneb. Will this act like any other visual, meaning when the report is refreshed, the data will load properly? Or will the code have to be adjusted every time new data is introduced? What are the limitations here in terms of robustness to future changes?

Thanks. 

[lbendlin]

Any idea if Deneb has a feature that allows the labels to be intelligently placed as to not overlap?

You would have to program the collision detection and avoidance yourself.

Or a way to match the label text color to the legend color?

yes, that's easy. Use the same color attribute

Will this act like any other visual, meaning when the report is refreshed, the data will load properly? 

yes

What are the limitations here in terms of robustness to future changes?

it's open source - so you can choose to fork it if you are concerned.  I have had a great experience so far. New Power BI centric features (formatting, interactivity) are being added all the time without impacting backward compatibility.

[DAX_merchant]

Thank you. I will look into it more and I appreciate your help.