[Line and stacked column chart] group the data in the same bar but different color

[Anonymous]

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

[v-yuta-msft]

@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.

[Anonymous]

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

[v-yuta-msft · Accepted 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.