Display shared axis issue for charts

[vijaykumarj19]

I had a table with 4 columns
ID , Date1 ,Date2, Date3

ID	Date1	Date2	Date2
100	22-05-2020	22-09-2020	22-06-2020
101	22-06-2020	22-08-2020	22-08-2020
102	22-07-2020	22-05-2020	22-10-2020
103	22-05-2020	22-05-2020	22-11-2020
104	22-08-2020	22-09-2020	22-05-2020
105	22-09-2020	22-12-2020	22-07-2020

May based on Date 1 has 2 id , date 2 has 1 id
Requirement

How could I take shared axis as there is no common field for month

[amitchandak]

@vijaykumarj19 , Option 1 is unpivot

https://radacad.com/pivot-and-unpivot-with-power-bi

Option 2 is that you join dates with a same date table and have one active and two inactive join and use userelation to create you measure on each date and add up

refer: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-Y...


Appreciate your Kudos.

[Greg_Deckler · Accepted solution]

You unpivot your date columns.