Forum Discussion

LucasP's avatar
LucasP
Regular Visitor
3 years ago
Solved

Concatenate Datas on same scatter plot

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

Need Help
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    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.

3 Replies