Percentile Charting

Thanks Jay, yes we had a contractor come up with that type of design, with a simple prototype bar/line combi and fixed, hard coded data sets and pre-calculated quintile bands for that data set which was  for illustration only for  the sort of functionality we may be able to leverage in the tool.

So as a Power BI novice it was tricky to envisage how we dynamically model the Quintile bands based on sliced selections of the main data set, so I was taking a punt to see if anyone had done similar or come across any custom visuals that may help our cause. I do appreciate your response.

My company does not allow sharing via drop box or one drive etc, so I screen shot the dashboard page, data and model for context and copied the values in the 2 tables.

The MAIN data set would be the type of data we would retrieve from our back end warehouse i.e. agent level metrics - albeit simplified, the Quintile linked table is the pre-calculated values the contractor set up for the illustration.

Btw I am not convinced the chart function and representation at the right quintile is working quite right tbh but hopefully this gives a gist.

FYI there are 2 metrics in the example a user would want to review: IPP and DISCOUNT hence why 2 charts but we would probably need to analyse any given metric in its  own merit so this may be muddying the current waters a little, so if we can get it working on a single chart  for one we should be able to apply to other metrics in similar fashion once we figured it out.