Forum Discussion
CSV values
TootsiePatootsiI mentioned you at the start of the thread, you have to split it to rows and eventually that is what unpivot did.
Regarding you have to create it for each column, it all depends what you are trying to do and what is the end goal. For now, solution was provided to get you the answer for your question but if there is something more required, list the full table columns and desired end result, it will help to provide you the best solution.
Sorry about that I am new to PowerBI I didnt expect that it unpivot will be the same result. I am thinking of having multiple copies of my datasource(referenced to my original one) for each fields with CSV on it. Now since I have multple datasource. Now since I have multiple data source I am not sure how can I make them be filtered by just 1 slicer