Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Eyad_Rish
New Member

Plotting line plot using two datasets with different x-axis intervals

Long story short, I have two datasets, dataset A and dataset B

 

Dataset A and B both have "distance" from origin and "speed" as coloumns

 

Dataset A is the permentant speed requirements while Dataset B gets refreshed in daily.

 

Datasset A has even values (2, 4, 6 ... etc) for distance while Dataset B has odd values (1, 3, 5, etc)

 

Essentially, trying to create a line plot using the two datasets so that X-axis is "distance" and Y-axis is "Speed". Problem is, when I try to plot them, it doesn't see shared x-axis values and gives me average speed as one constant value from Dataset B. 

 

Looking to plot both datasets on the same plot.

 

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

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')

vyangliumsft_0-1691721327260.png

Result:

vyangliumsft_1-1691721327265.png

 

 

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

View solution in original post

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

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')

vyangliumsft_0-1691721327260.png

Result:

vyangliumsft_1-1691721327265.png

 

 

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

amitchandak
Super User
Super User

@Eyad_Rish , Not very clear, seems like you need a table of values using generateseries and join it with both the tables

 

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

 

refer

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.