Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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

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?

 

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

 

Rajesh

  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous,

    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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks so much Lydia

       

      This worked!