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! 

6 Replies

  • 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! 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 months ago

    Hi,

    Unable to understand your requirement.  Share some data to work with and show the expected result.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 months ago

    Hi,

    Unable to understand your requirement.  Share some data to work with and show the expected result.