Scatter Chart: Comparing values in same column

[Anonymous]

Name	Date	Value
MaTMP	1/1/2022 8:00 PM	50.04
MaTMP	1/1/2022 7:45PM	50.06
MaTMP	1/1/2022 7:30 PM	50.6
OaTMP	1/1/2022 8:00 PM	33.49
OaTMP	1/1/2022 7:45PM	34.10
OaTMP	1/1/2022 7:30 PM	33.80

Here is sample data that i am using to create a Scatter Graph.  I am tring to have the MaTMP and OaTMP on the 2 axis and doing it by the date/time.  I have created 2 measure for these two points

MaTmp = CALCULATE(SUM(Query1[ActualValue]),FILTER(Query1,Query1[PointName]="XRDCWPDBSADX02:STNCRST-NAE02/N2-1.021083DX.MaTmp.#85"))

OaTmp = CALCULATE(SUM(Query1[ActualValue]),FILTER(Query1,Query1[PointName]="XRDCWPDBSADX02:STNCRST-NAE02/N2-1.021083DX.OaTmpGlobal.#85"))

I dont want to use the legend since there is 96 rows per day and i needing to trend this over a full year.  Below is what i am trying to recreate.  Any help would be appreciated.

[Greg_Deckler · Accepted solution]

@Anonymous Create 2 columns:

MaTMP = IF([Name]="MaTMP",[Value])

OaTmp = IF([Name]="OaTMP",[Value])

Use for your X-Axis and Y-Axis set to Sum. Use your Date as your Details.