Forum Discussion
Scatter plot data labels with x,y values
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!
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.
8 Replies
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-Forum/ba-p/963216
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/1447523Sample file can be found here:
The goal is for the data labels to not be A, B, C but the x, y coordinates
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.
