Scatter Chart || your x- and y-axis aren't playing together nicely

[arimoldi]

Hi,

I am trying to create on Power BI this graph using snapshot_date on x-axis and an amount values on y-axis:

but i get this error:

How can I solve this issue without using an aggregation on amount values?

Thanks,

Andrea

[Anonymous]

Hi @arimoldi ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data. 

(2) We can create a measure. 

Measure = SUM('Table'[value])

(3) Then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[arimoldi]

Hi,

Thanks for the reply.

The point is that I don't want to aggregate / summarize the values (with the sum we all agree it works), I just want to show each value with its date in the chart, as shown the graph from another tool I posted where the values are not aggregated/summarized.

Thanks,

Andrea

[Anonymous]

Hi @arimoldi ,

Do you mean for example if you have two different values for the same date such as

date	value
11/2/2023	10
11/2/2023	20

Do you want to display the visual object shown below?

Unfortunately this is not possible due to the design, if the only fields on your visual object are date and value then PBI will automatically aggregate values under the same date. If you don't want him to aggregate, you can create an index column for differentiation.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[arimoldi]

Thanks for the reply.

With this method I have 2 problems:

1. not all the data are shown as in my initial picture due to many values:
2. I have to add a legend based on a field category as shown in my intial picture, but having inserted the pk (index is not possibile because I am using direct query as I have 12.2M) I cannot add other fields to the legend:

Any other suggestion?

Thanks,

Andrea

[Anonymous · Accepted solution]

Hi @arimoldi ,

We apologize for the following limitations on scatterplots.

You can download or import custom visuals from Microsoft AppSource or Power BI. You can look for the availability of suitable custom visual objects.

If this doesn't help, you can vote the idea and comment here to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[arimoldi]

Any other suggestions?

I really can't believe that I cannot achieve this on Power BI while on other Data Viz tool there are no issues!

[Tahreem24]

@arimoldi  Scatter chart is used to compare two numeric values. Not sure why you put Date on x-axis because Date is a date type and Amount is a numeric type. You can refer the Microsoft blog on Scatter chart: Scatter, bubble, and dot plot charts in Power BI - Power BI | Microsoft Learn

Incase you don't need any summerization/aggregative so use  "Don't Summerize". Screen shot attached for your reference.

[arimoldi]

Hi,

the mean of the graph is to show the distribution of the amount values over time.

The "Don't Summerize" is already selected and I get the above error; if I select any other aggregation I don't get the error but the outcome is not what I want (it is not as the graph showed above).

Any other suggestions?

[Tahreem24]

@arimoldi If you want to show Amount over a time so best way to represent it using all these charts which I highlighted in yellow color.

[arimoldi]

If I use one of those graph the "Don't Summerize" option isn't available anymore.