Forum Discussion
Anonymous
8 years agoNot applicable
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?
| 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
- Anonymous8 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
- AnonymousNot 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- AnonymousNot applicable
Thanks so much Lydia
This worked!