What chart or graph do i use to compare time between dates?

[Rocky_Brown]

I have the following data:

Created Date

Invoiced Date

Region

I want to chart out somethng like

                                                 ---------------------------------------created date

                                                 ---------------------------------------Invoice Date

                                                                Region

In a line chart.  Can this be done?  

Cant figure out how to bring in the data

The lines will fluctuate depending on days between invoice date and created date.

[amitchandak · Accepted solution]

@Rocky_Brown , With a common date table, You can create measures that work on create date and Invoice date. Use userelationship for inactive dates 

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

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous · Accepted solution]

Hi @Rocky_Brown 

You can calculate the diff between two dates .

Region = DATEDIFF(SELECTEDVALUE('Table'[Created Date]),SELECTEDVALUE('Table'[Invoiced Date]),DAY)

Then add a line chart , use [name] as Axis ,[region] as value .

The effect is as shown:

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Rocky_Brown , With a common date table, You can create measures that work on create date and Invoice date. Use userelationship for inactive dates 

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

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.