cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
trangvo Regular Visitor
Regular Visitor

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

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.

image.png

 

Many thanks in advance.

Trang

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

@trangvo ,

 

Click arrived and left column, unpivot. You may refer to the pbix.

Capture.PNG '

 

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

3 REPLIES 3
Community Support Team
Community Support Team

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

@trangvo ,

 

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.

Capture.PNG 

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.

trangvo Regular Visitor
Regular Visitor

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

Hi  

 

 

 

 

 

 

 

 

Community Support Team
Community Support Team

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

@trangvo ,

 

Click arrived and left column, unpivot. You may refer to the pbix.

Capture.PNG '

 

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

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,130)