Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

[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

@Anonymous ,

 

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
v-yuta-msft
Community Support
Community Support

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

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.

Anonymous
Not applicable

Hi  

 

 

 

 

 

 

 

 

@Anonymous ,

 

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.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.