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
dramus's avatar
dramus
Continued Contributor
8 years ago

Which columns did you have selected when you tried to unpivot?

 

It should look like this before you do the unpivot:

 

 

Make sure all three of the "Column Values" columns are selected and then Right click on one of the headers and select "Unpivot Columns"

dramus's avatar
dramus
Continued Contributor
8 years ago

Or...You can right click the "#"/Requests column, and select the "Unpivot Other Colu,mns" option. Same result.

  • TootsiePatootsi's avatar
    TootsiePatootsi
    Regular Visitor
    8 years ago

    Hi Dramus,

     

    Thanks for helping me out here. Just to be sure I need to split them to columns right then unpivot the columns the all new columns?

    • dramus's avatar
      dramus
      Continued Contributor
      8 years ago

      Yes. Split and then unpivot.

      • TootsiePatootsi's avatar
        TootsiePatootsi
        Regular Visitor
        8 years ago

        Ill try it out, my data is quite large it takes quite a few minutes for the unpivot. Let you know what would be the result