Relationship between date columns isn't working

[AHANABISWAS]

Hi,

I have 2 tables Headcount Tracker ad Volume Summary, both has a date column (in the same format dd-mm-yyyy, i have changed the format for both to mmm-yy). I have linked these 2 date columns (many to many relationship).

I have created 2 separate measures using the values from each table FTE per month from Headcount tracker table & Suggested FTE per vol from Volume summary table. Now I want to display both these measures in a line chart with month in x Axis. However, one of 2 measures isn't displayed as expected against the month axis.

When I checked the month columns, one of those 2 doesn't give me the date hierarchy option.

How can I display these 2 measures against the month axis ? 

Regards

[Anonymous]

Hi @AHANABISWAS ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[Anonymous]

Hi @AHANABISWAS ,

Generally speaking, the relationship between the calendar table and the main table is set as follows.

If it still failed, you could try like.

Reference: Create and manage relationships in Power BI Desktop

Best Regards,

Stephen Tao

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