Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Plotting 2 Dates on X axis - Time Series graph

Hello,

 

I am having issues getting two dates (planned dates for functional testing software v. actual executed date of testing software) to plot on the same x-axis of a line graph. I want to be able to slice the line graph by the name of the tester to track team progress towards the goal over time. Some executed dates are the same day as the planned test date while others are few days later.

 

I created a reference date table, and then two separate tables to derive each date (planned v executed) from main source data and added the tester name information...I can't seem to make the relationship between the two date tables and the date reference table active so one line graph is always skewed. Apologies as I'm new to creating tables/relations in Power BI but any help very appreciated.

 

Creating Ref DateDate Connection from Ref Date to 2 Custom Created Date TablesDashboard

 

 

Need Help

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi Anonymous ,

    I have a little confused about your requirement.

    Do you want both of the two dates on the same x-axis in the line chart? And the two dates from the different table?

    Namely, do you want the x-axis dynamically change based on the name of the tester slicer?

    If it is convenient, could you share the data sample which could reproduce the scenario as table format so that I could have a test on it?

    Best Regards,

    Cherry

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi @v-piga-msft

       

      Sorry yes - I would like both dates on the same X-axis, I manually created the two date tables ("Planned Date" and "Executed Date") and populated them with data from the original table, but I don't know if that needs to be done at all, perhaps I can just use the original table.

       

      Essentially I just need the "System Cycle 1 Execution Date" column and the "Planned Execution Date" column from the original "Test Scenarios" table to be plotted on the same X axis and then for the "Tester" column to affect both dates when I filter on team member names to track individuals workload over time. Please let me know if this helps, I will need to receive approval to provide the raw data but will follow up if I can with that information.