Display Two Different Dates from the same point on the X axis.

[aulla]

Hi, me again.

I want to plot two lines that start from different dates in POWER BI.

I have products that have a differents date of creation and i have to display the product since it launch on a line chart as X=0, so that my users get an understanding of how the respective product have fallen in delincuency product launch.

This is what i currently have:

This just a running total of the percentage of clients that fell into delincuency, but notice that both of these linnes start at different dates, they should star at point 0, measured by the numbers of weeks since the product launched. Sometihng like:

Imagine that in the X axis we have numbers from 0 to whatever and that both start from 0, i just picked the two closest that i had.

I'll leave a mockup file attached, product of previous help: https://drive.google.com/file/d/1uems6jCzxqkJHNdtcnXxxHxBo222XPB1/view?usp=drive_link

[aulla · Accepted solution]

Hello Guys,

I just realized that this problem could be done by simply calculating the date differencente and creating a table of values from 0 to whatever the max difference is between dates. This table i can use it as if it was a "datetable" and then redo my running total based on it.

En result:

[lbendlin]

What should the granularity of your x axis be? Days?  What's the relevance of the products?

[aulla]

Hi @lbendlin ,

Should be weeks or months since creation date. The products have no relevance, in my case what i use to differenciate are the weeks or months these products were created.