Variable percentiles for different product groups

[Anonymous]

Good day,

I would like to have a summarized view different product groupings within my dataset. My data is in the following form:

I have n many variables, each row indicating a particular group the customer belongs to. I would like to have a percentiles view for each group type. The final dataset would take the following form for Group 1:

This view would show the front end user how the particular group behaves across the different variable types. 

I have done quite a bit of searching through the forums, looking for a way to create this interface - without any success. Could you please advise.

[v-diye-msft]

Hi @Anonymous 

I'd suggest you add the custom column and do some transformation in the query editor, you might consider creating a pbix file that will contain some sample data, upload the pbix to one drive or dropbox and share the link to the file. I'll draw it up for you.

[Anonymous]

Hi,

I have created a test file. Unfortunately, I cannot share the original data - as the data is proprietary.

https://www.dropbox.com/sh/1ynxde6ru1ogx0v/AAChiYE1ur_CE_jRrvAInp54a?dl=0

Thank you so much for your assistance.