Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

ProductCountryAvg Profit (per unit)
Product 1Country 1xyz
Product 1Country 2xyz
Product 1Country 3xyz
Product 1Country 4xyz
Product 1Country Nxyz
Product 2Country 1xyz
Product 2Country 3xyz
Product 2Country 5xyz
Product 2Country 9xyz
Product 2Country Nxyz
Product 5Country 3xyz
Product 5Country 7xyz
Product 5Country 8xyz
Product 5Country 11xyz
Product 5Country Nxyz
Product NCountry Nxyz

2 Replies