Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Selecting all columns from a Power BI table into table visual

Hi,    I have a table in Power BI where daily new columns will get added or some of the old column might get removed. and i have created a table visual. so, suppose if a new column is added then i ...
General Comment
Need Help
Tips and Tricks
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous ,

     

    You may try Unpivot Columns in Query Editor and use a Matrix visual to display the data.

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous ,

 

You may try Unpivot Columns in Query Editor and use a Matrix visual to display the data.

  • imocean's avatar
    imocean
    Frequent Visitor
    5 years ago

    Hi v-chuncz-msft ,

    How do we use Matrix visual to include all columns in a table? I couldn't see where I can do that... 

     

    Thanks
    Harrison

  • PowerBIStarling's avatar
    PowerBIStarling
    New Member
    2 years ago

    I have tables loaded and I see them in the data portion of the visualization screen to the right. They are not pivot tables.  
    How do I use unpivot to select all the columns as you have advised in your answer?
    Please, use small words and talk to me like I am dumb, becasue I do not understand.

    Thanks!