Forum Discussion
Display shared axis issue for charts
- 6 years agoYou 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.