Forum Discussion

TootsiePatootsi's avatar
TootsiePatootsi
Regular Visitor
8 years ago

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 ...
Need Help
TootsiePatootsi's avatar
TootsiePatootsi
Regular Visitor
8 years ago

Hi Dramus,

 

I was able to solve the issue but its doesn't turn out to be what I was expecting. I use the unpivot but result is somehow the same with splitting a column into multiple rows instead of column. And also I had to do this with other column does it mean each column with CSV on it I had to create a new data source?

dramus's avatar
dramus
Continued Contributor
8 years ago

TootsiePatootsiWe are working against the very limited dataset you provided (2 columns, 3 rows). If you can provide something that's closer to your real dataset, we might be able to give you an answer, but with what we have at the moment, I'm not sure that we can reproduce what you are trying to do and give you an exact answer.

 

Can you share (even privately) your PBIX file?

  • TootsiePatootsi's avatar
    TootsiePatootsi
    Regular Visitor
    8 years ago

    HI Dramus,

     

    Sorry but I cannot share the pbix its quite to confidential. I ended up having multiple datasource for each fields that has CSV. Not sure now how to use slicer filter graphs/report that came from different data source

  • dramus's avatar
    dramus
    Continued Contributor
    8 years ago

    Without knowing more about your model, I'm not sure I can give you any advice on how to make the filters work.