Line chart showing values from two different tables

[jereaallikko]

Hi,

I am trying to create a simple line chart showing data from two different tables.

Both tables contains several parameters, such as date, ID, person etc. There are over 1000 records, so I will just try to demonstrate.

The end result should look like this:

Ideally I would like to maintain the date hierarchy and change it between Y-Q-M-D, so that it applies to both lines.

Do I have to create some kind of DAX measure(s) and establish relationships between the tables to make it work properly?

Any tips?

[jereaallikko]

Hi @VahidDM @PaulDBrown @amitchandak,

Thanks for your replies, all of them were helpful. I got the problem solved by creating the date table with instructions by @VahidDM. Then I connected the date columns from both tables to date table. Needed to make sure that each column was the type of "date" and not f.ex "date/time".

Thanks everyone.

BR,

Jere

[VahidDM · Accepted solution]

Hi @jereaallikko 

You need to have a Calendar/date table and add connect your tables to that date table. use date table dates as axis data and the value of your table as the value of the line chart.

if you want to create a date table see this link:

https://www.vahiddm.com/post/creating-calendar-table-with-3-steps

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

[PaulDBrown]

You need to create dimension tables with unique values covering the range of values for each field common to both tables, including a Date Table. You then create one-to-many relationships (single direction) from the dimension tables to the corresponing fields in the fact tables, and use these dimension table fields in visuals, filters, slicers and measures. In your example, you use fields from the Date Table as the x-axis and measures for the calculations for the values

[amitchandak]

@jereaallikko , You should create a date table and join it with date.

And there you can have a column

Custom = format([date], "YYYY \QQ MMM DD" )

Sort this on the date column