Forum Discussion
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 have to drag it into Values field of the table visual daily. I can not do this daily.
Is there any way where table visual will be created regardless of how many and what columns are present and i dont need to drag/remove the column to a visual daily.
Thanks,
Shubham
Anonymous ,
You may try Unpivot Columns in Query Editor and use a Matrix visual to display the data.
5 Replies
Anonymous ,
You may try Unpivot Columns in Query Editor and use a Matrix visual to display the data.
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
HarrisonI 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!
Hi Anonymous ,
Have you got this sorted? I'm facing the same challenge and couldn't see how the matrix visual can do that... Would really appreicate it if you can share how you've achieved it.
Thanks!
I had the EXACT SAME challenge in Power BI, struggeling with it for days now. THANK YOU! 😃
