Forum Discussion
Visual different dates
| 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
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.
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.
6 Replies
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.
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
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.
Anonymous
