Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
JohnnyK
Advocate II
Advocate II

Not to show Category labels in scatter plot

Data as below, I made a scatter plot with it and want to show the data labels of each scatter.

 

NameWeekSales
David112
David24.5
David313.5
David415
David56
David621
David73
David89
David90
David1015
David1113.5
Nancy112
Nancy23
Nancy39
Nancy40
Nancy50
Nancy60
Nancy70
Nancy81.5
Nancy94.5
Nancy100

 

By ticking the "Category Labels", it shows the Category and the values of the scatter.

 

Is there a way to only show the values of the scatters, but no Category? like the first scatter "1 12" to "12"? Thank you.

(all scatters, not a specific scatter)

 

5-18-2021 4-15-41 PM.png

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @JohnnyK ,

 

This has to do with the type of aggregation you make on the week, and sales.

 

If you select don't summarize on both you will have the scatter has you show, if you select and aggregation on the week you will only get the data label with the sales amount,

 

However all the values that are zero will only ne presented in the first time they appear:

MFelix_0-1621420017261.png

For this type of visualization would it not be better to use a line chart and hide the lines:

MFelix_1-1621420125121.png

 

You just need to change the shapes settings:

 

MFelix_2-1621420170463.png

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

2 REPLIES 2
MFelix
Super User
Super User

Hi @JohnnyK ,

 

This has to do with the type of aggregation you make on the week, and sales.

 

If you select don't summarize on both you will have the scatter has you show, if you select and aggregation on the week you will only get the data label with the sales amount,

 

However all the values that are zero will only ne presented in the first time they appear:

MFelix_0-1621420017261.png

For this type of visualization would it not be better to use a line chart and hide the lines:

MFelix_1-1621420125121.png

 

You just need to change the shapes settings:

 

MFelix_2-1621420170463.png

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



@MFelix, marvelous! thank you for the teaching! excellent advice on the line chart!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors