Pareto chart with Other bar

[richardburling]

Hi all, 

I have done a little research and I am unable to find anything that meets my requirement. I have built a pareto chart but its currently displaying all of the causations along the x-axis, as there are nearly 200 of these its quite a long scroll. 😀

What I am after is when the cumulative total hits 80% I would like the remaining 20% of the causations wrapped up in to an 'Other' bar on the chart. This 'Other' bar would then total 100%. I am not even sure if its possible but it seems to be beyond my abilities at the moment so hopefully one of you can help, or at least point me in the right direction where I can do some more research. 

Thanks

Rich

[Fowmy]

@richardburling 

Can you share the formula you used for the Pareto calculation and sample data?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
How to paste sample data with your question?

 

[richardburling]

Hi Fowmy, 

Unfortunately I cant share the source data as it breaks GDPR. However, below is the DAX formula I used to create the Pareto line (this was adpated from a video on YouTube).

Pareto Line =
VAR TotalDue = CALCULATE(sum('FCT_LUL GBS Orders raw data for per'[Total Due (Incl VAT)]),ALLSELECTED('FCT_LUL GBS Orders raw data for per'))
VAR CurrentDue = sum('FCT_LUL GBS Orders raw data for per'[Total Due (Incl VAT)])
VAR SummerizedTable =
SUMMARIZE(
ALLSELECTED('FCT_LUL GBS Orders raw data for per'),
'FCT_LUL GBS Orders raw data for per'[Office],
"TotalDue",SUM('FCT_LUL GBS Orders raw data for per'[Total Due (Incl VAT)])
)
VAR CumulativeSum =
SUMX(
FILTER(SummerizedTable, [TotalDue] >= CurrentDue),
[TotalDue]
)
RETURN
CumulativeSum/TotalDue*100