Forum Discussion

nairisha's avatar
nairisha
Icon for Advocate I rankAdvocate I
10 years ago

Link Dates from two tables

Hi,   I have two tables in my database, one containing the traffic details in a shop and another containing the transaction. Each table records the datetime when someone entered the shop and purcha...
nairisha's avatar
nairisha
Icon for Advocate I rankAdvocate I
10 years ago

ankitpatira I don't want multiple x-axis. What I want to achieve is, suppose I have two tables 


 

 

 

 

 

 

 

 

 

 

What I would like to achieve is a X-axis of may be date and Y-axis having both value 1 and value 2 on a clustered column chart.

 

 

 

 

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

nairisha In powerbi desktop, go to query editor (Edit Queries), on Home ribbon, under Combine tab, click Merge Queries.Select date column from both the tables and appropriate join type. Result will give you combine date with values from both tables that you can plot on x and y axis.