Forum Discussion
Plotting line plot using two datasets with different x-axis intervals
- Anonymous3 years ago
Hi Eyad_Rish ,
Whether your two data sets can not connect the relationship between the columns, such as [distance], A table [distance] is an even value, B table is an odd value, there is not a relationship between them can connect the columns, the two columns together in the line chart, there will be "Can't display the data because Power BI can't determine the relationship between two or more fields", if you just put A table [distance], will only display the table in the [Speed]. data because Power BI can't determine the relationship between two or more fields", if you just put the [distance] in table A, it will only display the [Speed] in this table, and will not display the [Speed] in table B. If you just put [distance] from table A, it will only show [Speed] from this table and not [Speed] from table B, because there is no corresponding value.
You can consider creating a table to join the two tables:
Table = UNION( 'TableA','TableB')Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Eyad_Rish ,
Whether your two data sets can not connect the relationship between the columns, such as [distance], A table [distance] is an even value, B table is an odd value, there is not a relationship between them can connect the columns, the two columns together in the line chart, there will be "Can't display the data because Power BI can't determine the relationship between two or more fields", if you just put A table [distance], will only display the table in the [Speed]. data because Power BI can't determine the relationship between two or more fields", if you just put the [distance] in table A, it will only display the [Speed] in this table, and will not display the [Speed] in table B. If you just put [distance] from table A, it will only show [Speed] from this table and not [Speed] from table B, because there is no corresponding value.
You can consider creating a table to join the two tables:
Table =
UNION(
'TableA','TableB')
Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly