Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I have three years of organizational data showing FTE by business unit.
We want to present the data by unit, by current month (eg June), by year -- to compare June 16 to June 17 to June 18.
See attached for excel chart. I feel like this should be super easy in power BI but I can't see the solution. any help much appreciated. (Long time lurker, first time poster. I hope I'm attaching correctly.)
my data is organized by month and business unit. it's been unpivoted.
Solved! Go to Solution.
Hi @whatmary,
Based on my test, It is not possible to meet your exact same requirement as yours. However we can use column chart and Pie chart to work around.
Here I made a test and create four measures based on the sample data.
Jun 2018 = CALCULATE(SUM(Table1[FTE]),FILTER(Table1,Table1[MthYr]="Jun 2018"))
Jun 2016 = CALCULATE(SUM(Table1[FTE]),FILTER(Table1,Table1[MthYr]="Jun 2016"))
Jun 2017 = CALCULATE(SUM(Table1[FTE]),FILTER(Table1,Table1[MthYr]="Jun 2017"))
sum = [Jun 2016]+[Jun 2017]+[Jun 2018]
Then we can get the result as below.
For more details, please check the pbix as attached.
https://www.dropbox.com/s/kqhf3m66zmo5w4r/22.pbix?dl=0
Regards,
Frank
Hi @whatmary,
Based on my test, It is not possible to meet your exact same requirement as yours. However we can use column chart and Pie chart to work around.
Here I made a test and create four measures based on the sample data.
Jun 2018 = CALCULATE(SUM(Table1[FTE]),FILTER(Table1,Table1[MthYr]="Jun 2018"))
Jun 2016 = CALCULATE(SUM(Table1[FTE]),FILTER(Table1,Table1[MthYr]="Jun 2016"))
Jun 2017 = CALCULATE(SUM(Table1[FTE]),FILTER(Table1,Table1[MthYr]="Jun 2017"))
sum = [Jun 2016]+[Jun 2017]+[Jun 2018]
Then we can get the result as below.
For more details, please check the pbix as attached.
https://www.dropbox.com/s/kqhf3m66zmo5w4r/22.pbix?dl=0
Regards,
Frank
sorry! I unexpectely was off work on friday and just now am getting back to my pbi project. Thank you so much for your help!!
Hi @whatmary,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.