Visual different dates

[Romani]

CUSTOMER_NAME	OFFERS_DATE	OFFER_ACCEPTANCE_DATE	REJECTION_DATE	INVEST_DATE	SUBMISSION_TO_R	SUBMISSION_DATE_TO_C	APPROVAL_DATE
Client 85	3/27/2023	3/27/2023		1/29/2024	3/28/2023	3/28/2023	3/27/2023

I presented an offer the client 85 and as the data provided the client has been walk throgh of different dates 
what i want to visual these dates to tell the story of the client and the different stages he walk through and i the total days that this client takes to the last stage however what the stage is

[Anonymous · Accepted solution]

Hi @Romani ,

Thanks for reaching out us. You can using the feature "Unpivot Other Columns" to make dates in one column.

For example, select the CUSTOMER_NAME column and unpivot other columns.

In Desktop, now you can create visuals you need with these columns.

Best Regards,

Stephen Tao

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

[Romani]

@Anonymous 

[Anonymous · Accepted solution]

Hi @Romani ,

Thanks for reaching out us. You can using the feature "Unpivot Other Columns" to make dates in one column.

For example, select the CUSTOMER_NAME column and unpivot other columns.

In Desktop, now you can create visuals you need with these columns.

Best Regards,

Stephen Tao

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

[Romani]

Your idea is more than perfect but the issue is i dont have access to power query edito due too some security layers 

There is a way to achieve the needed output

[Anonymous]

Hi @Romani ,

Thanks for your response.

After reviewing your post and understanding that you can't go to Power Query. You can try this alternative workaround.

You want to see the days between dates, right?

Please try the DATEDIFF function. You can create measures or calculated columns, either of which. Here I created calculated columns.

Days acceptance = DATEDIFF([OFFERS_DATE],[OFFER_ACCEPTANCE_DATE],DAY)

Days between OFFERS and INVEST = DATEDIFF([OFFERS_DATE],'Table'[INVEST_DATE],DAY)

Then you can try different visuals to show the days. Because the sample data is simple, the visuals may not look particularly good.

Best Regards,

Stephen Tao

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

[Romani]

No you didnt get my point 
what i want to visual the client journey throgh different dates 
so i want something like line chart to told me that the:

Client 85
has offer in 3/27/2023
he accepted the offer in 3/27/2023
then SUBMISSION_TO_R in 3/28/2023
then to investigation in 1/29/2024

so i want visual could help me to achieve that point

[Anonymous · Accepted solution]

Hi @Romani ,

I see, the workaround in my first reply is actually correct, but you can't go into Power Query.

There's no better way to do that than to get into Power Query. Or you can experiment with some visuals to see if they meet your needs, such as: Decomopisiton tree visual.

Best Regards,

Stephen Tao

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