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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ghe7549
Helper III
Helper III

Scatter Chart: Comparing values in same column

NameDateValue
MaTMP1/1/2022 8:00 PM50.04
MaTMP1/1/2022 7:45PM50.06
MaTMP1/1/2022 7:30 PM50.6
OaTMP1/1/2022 8:00 PM33.49
OaTMP1/1/2022 7:45PM34.10
OaTMP1/1/2022 7:30 PM33.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.

 

ghe7549_1-1644087097976.png

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@ghe7549 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.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

@ghe7549 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.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.