Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
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.
Trang
Solved! Go to Solution.
@Anonymous ,
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.
@Anonymous ,
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.
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.
Hi v-yuta-msft,
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.
Trang
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |