Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
@paulfink , for this one it is better to unpivot the data so that you will get stage and date as columns
User | Count |
---|---|
73 | |
69 | |
36 | |
26 | |
24 |
User | Count |
---|---|
97 | |
92 | |
54 | |
45 | |
41 |