cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vijaykumarj19
Microsoft
Microsoft

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

 

Capture.JPG

 

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

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

You unpivot your date columns.

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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.

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
Greg_Deckler
Super User
Super User

You unpivot your date columns.

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.