Three data sets with a common axis on a Scatter plot in Power BI

[Rajesh_G]

Hi 

I have three data sets as shown in the table below, however all three data sets have a common independent x-axis as can be seen. 

I am struggling on how to plot them all using a Scatter plot or something similar in POWER BI - can anybody help?

Day	Column 1	Column 2	Column 3
1,00			15,30000019
2,00		14,75767994
3,00	15,21474934
4,00		15,07311153
5,00			15,22067356
6,00		15,07402611
7,00			15,22335052
8,00			15
9,00	14,92468929
10,00		15,10758114
11,00			15,23837376
12,00		14,9546299
13,00			14,99088001
14,00	15,10000038
15,00		14,75522232
16,00			14,78763294

Rajesh

[v-yuezhe-msft · Accepted solution]

@Rajesh_G,

Unpivot your columns in Query Editor of Power BI Desktop, then create scatter chart as shown in the following screenshots and check if you get expected result.


Regards,
Lydia

[Rajesh_G]

Thanks so much Lydia

This worked!