Forum Discussion
TootsiePatootsi
8 years agoRegular Visitor
CSV values
Hi, First of all thanks for reading this. I am new to PowerBI so I am hoping you could help me out. I have the following data # Column Values Request #1 A,B,C Request #2 C,A ...
parry2k
Super User
8 years agoMake sure to split it in rows and then you can get what you are looking for:
TootsiePatootsi
8 years agoRegular Visitor
Hi,
Thanks for the reply. I tried it out but somehow other data was also duplicated
| # | Column | Other Columns |
| Request #1 | A,B,C | Value 1 |
| Request #2 | C,A | Values 2 |
After splitting it my table turns into this which affects my other report:
| # | Column | Other Columns |
| Request #1 | A | Value 1 |
| Request #1 | B | Value 1 |
| Request #1 | C | Value 1 |
| Request #2 | C | Values 2 |
| Request #2 | A | Values 2 |