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
JuanBolas
Helper II
Helper II

Problems calculating 12 month average and Pareto percentage

Hello,

 

I'm having trouble with a couple of problems with two things.

 

1) calculating a twelve month average of the total trips per month to add as a line graph on a visual.

 

2) I've setup a pareto chart that seems to have an error when calculating the cumulative percentage.

 

I haven't been able to figure out either one.

 

Please help me.

 

The data and reports are included in a pruned shared PBIX.

 

Thanks in advance

 

https://drive.google.com/file/d/1GaNVC5Oufq8-qmjDMaheVRdy57w1LN7E/view?usp=sharing

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

twelve months of what? Previous months? Previous and current?  Sliding window of six previous and six next?

 

Attached is a proposed solution.  for breaking Pareto ties use a small random number to add to your y axis.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

twelve months of what? Previous months? Previous and current?  Sliding window of six previous and six next?

 

Attached is a proposed solution.  for breaking Pareto ties use a small random number to add to your y axis.

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.