Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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.
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |