Forum Discussion
Add a total point into Scatter chart
Hi,
I need to add the total in the scatter chart.
As seen in the example image: a point, of different color with written "Total" that reflects the totals of the measures as in the table.
Table:
X Value Date
| A | 982 | 01.01.2021 |
| B | 479 | 01.01.2021 |
| C | 345 | 01.01.2021 |
| D | 547 | 01.01.2021 |
| E | 458 | 01.01.2021 |
| F | 376 | 01.01.2021 |
| A | 458 | 01.02.2021 |
| B | 763 | 01.02.2021 |
| C | 345 | 01.02.2021 |
| D | 835 | 01.02.2021 |
| E | 279 | 01.02.2021 |
| F | 665 | 01.02.2021 |
| A | 111 | 01.03.2021 |
| B | 999 | 01.03.2021 |
| C | 888 | 01.03.2021 |
| D | 777 | 01.03.2021 |
| E | 666 | 01.03.2021 |
| F | 444 | 01.03.2021 |
M1 = STDEVX.P(VALUES('Table'[Date]), CALCULATE(SUM('Table'[Value])))*SQRT(365)
M2 = STDEVX.P(VALUES('Table'[Date]), CALCULATE(SUM('Table'[Value])))*SQRT(30)
Thanks
3 Replies
Giadev
Not very clear, what is the value of the total? Sum of all X? Or lets what are the content do you expect to display in the total node like below.Paul Zheng _ Community Support Team
The total of the measure like in the table:
Hi Giadev,
I know this post is almost 2 years old, however, did you ever find a solution to adding a total to the scatter plot?
Thanks!
