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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Happy2023_05
Helper I
Helper I

How to show value instead of aggregate in scatter plot

How to show value instead of aggregate in scatter plot?

I just have table like this

X.    Y

aa.  2

aa.  3

aa.  4

bb 5

I should show aa as 4 data points(without summarising to 9) and bb as 1 data point using scatter plot. Kindly help

 

 

 

 

3 REPLIES 3
Happy2023_05
Helper I
Helper I

Thanks for responding. 

I don't want to sumamarize y columns. I want to see it as separate data points and X column should be in x axis and used as legend. Is there any suggestion for this to achieve?

v-yetao1-msft
Community Support
Community Support

Hi @Happy2023_05 

For scatter plot , X axis and y axis aren't playing together nicely , replace the X axis field with a numerical value or change the Y axis field values to summarizations . So if you want through X axis to dispaly your X value , you need to add a column and put it in Legend . 

Ailsamsft_0-1666940479036.png

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Happy2023_05
Helper I
Helper I

Can someone please help me on this?

Scatter plot when giving x-axis text and y axis - number field as don't summarize to see individual data points but I get this error.

 

X axis and yaxis aren't playing together nicely. Because one of the axis expecting numerical value. How to fix this error and how can I see individual data points without aggregation?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.