Multiple date fields in a visual that have a shared axis from calendar table

[paulfink]

Hi guys,

got a pick of a head scratcher.

I need to make a visual that shows how many sales have progressed in a month this year.

I have the dates in which they moved but there are different sale stages so i have 6 different columns with dates.

what i need is to put them in a stacked column chart with the Shared Axis as the Calendar Table 'Period' e.g. Dec-21.

How can i do it so that each calendar period has only the dates in which the sales entered that stage.

like this:

SS1	SS2	SS3	SS4	SS5	SS6
07/06/2021
	15/07/2021
		20/08/2021
			17/10/2021
				30/10/2021
					24/11/2021

i am unsure if there will be multiple dates in a single row - if there can only be 1 can simply merge the columns into one and go from there but if there is multiple in a row, what should i do

this is how the data looks - i want each of those dates to only go into the period it relates to 

i want it to show like this:

how can i do this? is this possible?

[amitchandak]

@paulfink , for this one it is better to unpivot the data so that you will get stage and date as columns 

https://radacad.com/pivot-and-unpivot-with-power-bi