Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@Anonymous ,
You may try Unpivot Columns in Query Editor and use a Matrix visual to display the data.
I had the EXACT SAME challenge in Power BI, struggeling with it for days now. THANK YOU! 😃
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!
@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
Harrison
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |