Forum Discussion

AHANABISWAS's avatar
AHANABISWAS
Frequent Visitor
5 years ago

Relationship between date columns isn't working

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

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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