Forum Discussion
How to manipulate this confusing data set
So i have a dataset that looks like this pretty much. Much more regions and areas of 'proffecincy' of course. So how the data is listed it shows indiviuals and the regions they have done activity. It also shows what type of activity and their 'profeciency' in it. I want to be able to list all the indiviuals in a table in PBI. Then I want to have filters that say Region, area of proffenciy & level of proffenciey. So the user can locate the indiviuals they want. Let me know if I should provide any furthur information.
1 Reply
Hello,
Here is one to go about this. It will require you to transform the data in a way. Consider the following:- Transpose your data so that it falls into a single column, so that the region that is listed as "TRUE" for the individual is the only thing that would show in the region column for multiple rows. For example, it would look like this:
Name Region James Atlanta James New York George New Jersey Tim None
You can apply the same methodology for your activity, but you'll have to create multiple rows for each record. Depending on your data needs, you could leave the proficiency columns as is, but you may find some challenges when it comes to how you analyze your data further down the line.
