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
jbhavesh077
Frequent Visitor

Effective Date related mapping

Hi team,

 

I have got a requirement which has 5 columns in it(something similar to like this) namely employee, manager, start date , end date and sales value and the employees are working under different managers in one calendar year. How do we display it in the form of pie-chart with the change of an employee from one manager to another reflected with the end date in the pie-chart?

 

Any help on it will be appreciated.

 

Thanks!

2 REPLIES 2
v-qiuyu-msft
Community Support
Community Support

Hi @jbhavesh077,

 

Please share some sample data and clarify corresponding desired results. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Qiuyun,

 

Please find below the sample data for which I am looking to plot a pie chart

EmployeeManagerStart dateEnd dateNo of Sales Unit
JohnRossy1/1/20183/31/201810
SteveSmith1/1/20187/31/201812
BillSandra1/1/20186/30/201822
JackRossy1/1/201812/31/201840
MaryRossy1/1/201812/31/201824
AnnaSandra1/1/201812/31/201822
EricAllan1/1/201812/31/20189
JimmyAllan1/1/201812/31/201810
JohnSmith4/1/201812/31/201914
SteveRossy8/1/201812/31/20185
MarkSmith1/1/201812/31/201818
BillAllan7/1/201812/31/201836

 

 

I am able to display the data in the form of pie-chart but I am unable to reflect the change of managers in it. The employees are being dispayed in both of their managers listing in the pie chart(the previous and present manager under which they been associated).

 

Could you please help me with the steps to implement it or any kind of help will be appreciated?

 

Thanks and Regards,

Bhavesh

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.