Forum Discussion

Ntshepi's avatar
Ntshepi
Frequent Visitor
8 months ago
Solved

Pivoting Column changed my data field into column headers

Hi, there's a comment section column from a Powerapps that makes some parts of some comments column headers. Please suggest how do i stop this from happening
Tips and Tricks
  • Ntshepi's avatar
    Ntshepi
    8 months ago

    Hi there my good people. I found a solution to my earlier predicament. I hadn't noticed the slight but impactful mistake I made- I split my values column with a comma delimeter, which caused the few comments that had a comma in them get split as well. Ah, the tales of being an entry level data analyst starting with Power Bi... Thank you all for your messages! 

danextian's avatar
danextian
Super User
8 months ago

Hi Ntshepi 

That is exactly what pivoting does - very similar to what pivot  in Excel does. Post a workable sample data (not an image) and your expected result from that. 

    • Ntshepi's avatar
      Ntshepi
      Frequent Visitor
      8 months ago

      Hi there my good people. I found a solution to my earlier predicament. I hadn't noticed the slight but impactful mistake I made- I split my values column with a comma delimeter, which caused the few comments that had a comma in them get split as well. Ah, the tales of being an entry level data analyst starting with Power Bi... Thank you all for your messages! 

      • v-aatheeque's avatar
        v-aatheeque
        Community Support
        7 months ago

        Hi  Ntshepi 

        That’s great to hear, thank you for the update!

        Glad you were able to identify the root cause and resolve the issue.