Forum Discussion
Quartile split based on segmented data
Hi Power BI community,
I am working with some data that has been simplified in the below table.
What I am trying to do is split the data into quartiles based on a selected product. So if Product 2 is selected in a slicer/dropdown, what I would like is the sales data for that product split into 4 quartiles i.e. quartile 1 is the best performing countries in terms of Avg Profit (per unit), and quartile 4 the worst performing countries.. It's possible I may have certain products with sales in less than 4 countries, in which case they can go into the relevant quartiles in order from 1 to 2 to 3.
I would like to use the quartiles as visual filters after.
I've read several threads but can't figure out how I might do this, so any guidance would be appreciated.
| Product | Country | Avg Profit (per unit) |
| Product 1 | Country 1 | xyz |
| Product 1 | Country 2 | xyz |
| Product 1 | Country 3 | xyz |
| Product 1 | Country 4 | xyz |
| Product 1 | Country N | xyz |
| Product 2 | Country 1 | xyz |
| Product 2 | Country 3 | xyz |
| Product 2 | Country 5 | xyz |
| Product 2 | Country 9 | xyz |
| Product 2 | Country N | xyz |
| Product 5 | Country 3 | xyz |
| Product 5 | Country 7 | xyz |
| Product 5 | Country 8 | xyz |
| Product 5 | Country 11 | xyz |
| Product 5 | Country N | xyz |
| Product N | Country N | xyz |
2 Replies
- Greg_DecklerCommunity Champion
This sounds like Dynamic ABC classification although it sounds like you want dynamic ABCD classification:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-ABC-Classification/m-p/479146#M180
- V-lianl-msftCommunity Support
Hi Anonymous ,
You can refer to this thread:https://community.powerbi.com/t5/Desktop/quartile-ranking/m-p/560850
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.