Concatenate Datas on same scatter plot

[LucasP]

Hi all,

I'm new using Power BI and i have difficult to create a plot with "concatenate" data on the same plot from differents tables.

To be quick, i have differents table (3 for exemple) and i want to plot datas one after the others as below on Excel.

In Data 1/2 & 3 i have for exemple "Temperature" depending on time, all start from "0sec". So i need to create another "time data" to concatenate and offset data correctly depending on a "global time".

But, i don't know how to do that on Power BI knowing that i received datas on 3 differents tables.

Have you an idea how i could do that please ?

Thanks a lot for your help.

PS : Sorry if it's not really clear..

[v-yadongf-msft · Accepted solution]

Hi @LucasP ,

Sorry, the link you gave cannot be opened.

I suggest you to combine the three tables into one table.

NewTable = UNION('Table1','Table2','Table3')

Type = SWITCH(
    TRUE(),
    'NewTable'[ID] = 1 || 'NewTable'[ID] =2 || 'NewTable'[ID] =3, "Data1",
    'NewTable'[ID] = 4 || 'NewTable'[ID] =5 || 'NewTable'[ID] =6, "Data2",
    'NewTable'[ID] = 7 || 'NewTable'[ID] =8, "Data3")

The result you want:

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PaulDBrown]

Please share sample non-confidential data or a link to a sanitized PBIX file

[LucasP]

Thank you ! https://app.powerbi.com/links/6dBH-hHzkb?ctid=c4d38269-36ae-4f25-9968-2dff68af5347&pbi_source=linkSh...