Cross plot of same field with two different filters applied

[PowerOper]

I have a table 'tbl_values' with 3 fields that stores time and value pairs for different entities

• [entity_ID]
• [time]
• [value] 

I would like to cross plot the values for one entity_ID vs. the values of a second entity_ID within the same time range.  It is safe to assume that for each [time] there is a [value] for each [entity_ID]

I can't figure out how to do this!  Do I need to generate another table in order to do this? It would be nice to have 2 slicers on entity_ID to select each entity for the crossplot, but I'm unable to drag the [value] item twice to the same plot and I'm not sure how to create a measure that would reference the slicer selection.   Even if I can get one cross plot working, I can probably figure out the slicer afterwards...

Any ideas?

[v-lili6-msft]

hi, @PowerOper 

Sample data and expected output would help tremendously. 
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Lin

[PowerOper]

Hi, here is some sample data to show what I am looking to do.   I would like to specify 2 entity_ID values, and extract the values at coinciding times for each entity_ID to cross plot one vs the other.

SAMPLE DATA
tbl_values
entity_ID	time	value
100	2019-09-01 0:00	518
100	2019-09-01 1:00	578
100	2019-09-01 2:00	541
100	2019-09-01 3:00	600
100	2019-09-01 4:00	551
100	2019-09-01 5:00	430
100	2019-09-01 6:00	446
100	2019-09-01 7:00	458
100	2019-09-01 8:00	490
100	2019-09-01 9:00	573
100	2019-09-01 10:00	545
100	2019-09-01 11:00	481
100	2019-09-01 12:00	519
200	2019-09-01 0:00	7,699
200	2019-09-01 1:00	8,560
200	2019-09-01 2:00	8,018
200	2019-09-01 3:00	8,900
200	2019-09-01 4:00	8,161
200	2019-09-01 5:00	6,611
200	2019-09-01 6:00	6,794
200	2019-09-01 7:00	6,935
200	2019-09-01 8:00	7,331
200	2019-09-01 9:00	8,485
200	2019-09-01 10:00	8,075
200	2019-09-01 11:00	7,217
200	2019-09-01 12:00	7,713

Desired Output for value crossplot: entity_ID=200 vs entity_ID=100

value_x	value_y
518	7,699
578	8,560
541	8,018
600	8,900
551	8,161
430	6,611
446	6,794
458	6,935
490	7,331
573	8,485
545	8,075
481	7,217
519	7,713

[PowerOper · Accepted solution]

I've solved my problem by adding 2 queries that select rows from the initial values table for a specific entity_ID