Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Change column data type

Hi all, this power BI newbie needs help with a challenging doosy.  I have a data source file with a list of people associated with a question and several choice answers: =choice  However, instead o...
prateekraina's avatar
prateekraina
Memorable Member
8 years ago

Hi Anonymous,

 

Would it be possible for you to draw what result you expect in Excel or Paint. I am a bit confused.

Is it something like below?

 



Prateek Raina

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi prateekraina,

see attached files, hopefull will explain a bit more.

I also created a pbix sample file. How can I share that with you?

 

As I've mentioned before, instead of separate columns with the same question/different choices, I'd like 1 column with the choices to pick from and be quantified, if you see in the Excel file, if you try to create a Pivot Table/Chart, all you get quantified are the checked/unchecked, not the actual choices.

 

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    Hi Anonymous

    A simple file will be really appreciated.

    You could upload the file by choosing files to the attachments below, or upload file to OneDrive, and then share me with the link.

     

    Best Regards

    Maggie 

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Maggie,

      thank you so much for your reply and wanting to help, but there's no option to upload a file that I can see here. Please advice

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      HI Maggie,

      haven't heard back from you.

      May I send you a sample file directly?

      Erick

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        8 years ago

        Hi Anonymous

        Could you see this when you reply?

        Yes, you can send email to me directly.

         

        Best Regards

        Maggie