Solved: Re: Data/Category Labels on Scatter Plot

Anonymous · ‎02-02-2021

I have a scatter chart visual in PowerBI, but the option to add data/category labels is not an option on for my chart. I want to add a label that calls out the y-value for each data point (Actual Wt). Help!

V-pazhen-msft · ‎02-04-2021

@Anonymous
@parry2k Indeed there is a category label feature in scatter plot, sorry to not explained correctly.

The reason the option does not show up is probably because you had a non-numerical value/text type column in the X axis. To be clear, if both X and Y axis are numerical field with “Don't summarize”, you should able to turn on the category label. So please check your data type, if you need a non-numerical on x-axis, you may use line chart.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

View solution in original post

V-pazhen-msft · ‎02-04-2021

@Anonymous
@parry2k Indeed there is a category label feature in scatter plot, sorry to not explained correctly.

The reason the option does not show up is probably because you had a non-numerical value/text type column in the X axis. To be clear, if both X and Y axis are numerical field with “Don't summarize”, you should able to turn on the category label. So please check your data type, if you need a non-numerical on x-axis, you may use line chart.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

parry2k · ‎02-04-2021

@V-pazhen-msft does not agree with you, you can show data category labels for scatter plot, in this case, I requested a sample file from @Anonymousto figure out a solution but unfortunately never received any reply. Having said that, you can always show category labels. Just my 2 cents.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

V-pazhen-msft · ‎02-04-2021

@Anonymous

Scatter plot do not support show data label, it could look confuse when many plots are included in the chart, maybe you could use line chart as an alternative.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

parry2k · ‎02-02-2021

@Anonymous Share sample pbix file, I might give it a try, it is not going to be straight forward, Remove sensitive information before sharing. Usually these kind of things are tricky and challenging and I love challenges and like to solve it (hopefully)

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

mahoneypat · ‎02-02-2021

Do you have a column in the Details field well? You need to have a column there and a summarization or measure for X and Y, or have it empty with "Don't Summarize" as the aggregation for both X and Y columns?

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube