Forum Discussion
Display shared axis issue for charts
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
- You unpivot your date columns.
2 Replies
- You unpivot your date columns.
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
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-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
Appreciate your Kudos.
