Hope someone here can advise me.
Here is the sample data :
Staff UserType Arrived Left
A1 External 22/03/2018 14/10/2019
A2 Internal 25/09/2017 24/10/2019
A3 External 25/09/2017 24/10/2019
A4 Internal 05/08/2019 31/12/2019
A5 External 19/02/2018 05/11/2018
A6 Internal 16/04/2018 02/09/2019
A7 External 01/10/2019 25/12/2019
A8 Internal 31/12/2019
A9 External 02/07/2018 25/09/2019
A10 Internal 28/05/2018 14/01/2020
A11 External 01/08/2018
A12 Internal 03/09/2018 04/01/2020
I would like to count :
- number of coming Internal / coming external
- number of leaving internal / leaving external
- The chart will have 1 bar for the leaving of internal and external employees, and one bar will be coming internal and external employees.
As the chart below, the blue and orange color must be in the same bar.
Many thanks in advance.
Go to Solution.
Click arrived and left column, unpivot. You may refer to the pbix.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
In query editor, click on Staff column-> click unpivot, then you will achieve two columns [Attribute] and [Value]. Create two stacked bar chart like below.
You can also refer to the pbix file.
thanks for your advise. Could you tell me if it's possible to have the 2 bars in the same chart ?
It means 1 bar of External/Internal arrived, and another bar of External/Internal left.
Thanks in advance.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!