Forum Discussion

Koritala's avatar
Koritala
Post Patron
1 year ago

Need To Show Column Values as different column headers

Hi ,

 

I have a column called "questions Text" Now all the question in table are showing as different rows. I want to show the questions Text column values as seperate columns in table visual.

Note: - My table is using the Direct Query mode. it doesn't have any measure columns and all columns values are attributes only.

Is there any solution to show all my questions Text columns values as separate columns using any approach.

 

Thanks,

Sri.

Need Help

6 Replies

  • srlabhe's avatar
    srlabhe
    Super User
    1 year ago

    Use the Matrix Visual from Visualization pane and add "Question Text" field as columns

    • Koritala's avatar
      Koritala
      Post Patron
      1 year ago

      Hi Srlabhe,

      we have huge volume of data and user not accepting the matrix. 

      Regards,

      Sri

      • srlabhe's avatar
        srlabhe
        Super User
        1 year ago

        Then even in any case how would you view report with such huge volume of data ?

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    Hi Koritala,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you srlabhe for the prompt response.

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user for the issue worked? Is your issue resolved? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa

    • v-achippa's avatar
      v-achippa
      Community Support
      11 months ago

      Hi @Koritala,

       

      We wanted to kindly follow up to check if the solution provided by the user for the issue worked? Is your issue resolved?

      If not please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
      Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
      Please show the expected outcome based on the sample data you provided.

       

      Need help uploading data? How to provide sample data in the Power BI Forum - Microsoft Fabric Community

       

      Thanks and regards,

      Anjan Kumar Chippa

       

      • v-achippa's avatar
        v-achippa
        Community Support
        11 months ago

        Hi @Koritala,

         

        As we haven’t heard back from you, we wanted to kindly follow up to check if your issue is resolved?

        We are closing this thread for now, if you have any other issues please raise a new thread in the community forum, we are ready to assist you on that.

         

        Thanks and regards,

        Anjan Kumar Chippa