Forum Discussion

vyacheslavg's avatar
vyacheslavg
Icon for Helper II rankHelper II
8 years ago
Solved

Add many columns to Table at Report View at once

Dear community, 

 

there is a one simple feature in Qlik, where I can add many, many columns to table visual on my report.

(by many I mean 20, 50, sometimes even more...).

 

I cannot find such feature in Power BI.

 

Could you please advise how I can do it? 

Maybe there is a custom visual for this?

 

thanks a lot in advance.

 

  • vyacheslavg's avatar
    vyacheslavg
    8 years ago

    Never mind, it looks like the mission impossible in Power BI itself.

     

    Though I've found that I can easily connect Excel to PBD internals, using DAX query and can create/modify tables on the fly and put it to linked to PBD Excel tables - thus my mission is accomplished.

     

    Thanks for your help anyway.

3 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi vyacheslavg,

    To my knowledge, you create a table visual, you can add many columns in the field zone highlighted in red line as follows.



    I am not familar with Olik, so I can't image what it looks like. If this is not what you want, please share more details for further analysis.

    Best Regards,
    Angelia

    • vyacheslavg's avatar
      vyacheslavg
      Icon for Helper II rankHelper II

      Never mind, it looks like the mission impossible in Power BI itself.

       

      Though I've found that I can easily connect Excel to PBD internals, using DAX query and can create/modify tables on the fly and put it to linked to PBD Excel tables - thus my mission is accomplished.

       

      Thanks for your help anyway.

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Icon for Microsoft Employee rankMicrosoft Employee

        Hi vyacheslavg,

        As you have resolved your issue, please mark your solution or helpful reply as answer, so more people can benefit from here, and we can close the thread, thanks for understanding.

        Best Regards,
        Angelia