Forum Discussion

mark123's avatar
mark123
New Member
6 years ago

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