Forum Discussion
Help presenting data in quintile groups
Hi,
I'm looking for some help creating a visual in Power BI to display my data range is 5 different groups. I'll use customer retention by product type as an example here.
I've got a long list of products, each with their own customer retention rate. I'm looking to create a visual that groups these retention rates into buckets of 20%, from the worst 20% of all the retention rates, up to the best 20%.
Ideally this will then be displayed like a continuum, with the bottom group as 'very poor', next group up 'poor', all the way up to the best as 'very good'. For example, if the worst retention rates are <60%, I'll have a dark red bar going up to 60%. If the next group is 60-75%, this range will then stack onto the first bar, in a lighter shade of red, and repeat for all 5 groups.
Couple of key points to add:
- I've got loads of metrics to recreate this for, so I'm looking to have the data automatically grouped into the 5 quintiles, not to set them myself.
- I'd also like to add a slicer to the front end so, for example, if the user wanted to look at monthly subscription products only, they can filter to this. The visual would then recalculate to include only the data points that meet this filter (in this case, monthly products).
If anyone has an idea on how I could make this work, please do have a go! I'm pretty new to Power BI so plenty of explanation alongside a solution will also be gratefully received!
Thanks
4 Replies
- Greg_Deckler
Community Champion
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
But, probably involves PERCENTILE.EXC or PERCENTILE.INC or PERCENTILEX.EXC or PERCENTILEX.INC.
Also, PERCENTILERANK from this may help:
https://community.powerbi.com/t5/Quick-Measures-Gallery/PERCENTILERANK/td-p/1082573
- amitchandak
Super User
mark123 , refer if this can help
- AnonymousNot applicable
Hi mark123,
Please share some dummy data and expected results to help us clarify your requirement. It is hard to test and coding formula without any sample data.
Regards,Xiaoxin Sheng
- AnonymousNot applicable
Hi mark123
Please check my solution in one of the previous posts.
Let me know if this helps. If yes, please share some Sample Data to help yo on this.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!