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

v-yadongf-msft's avatar
v-yadongf-msft
Community Support
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.