Forum Discussion
Anonymous
2 years agoNot applicable
Add columns to a table visual dynamically
Hello community, I have a table that comes from a SQL Server Procedure (let's say table1). This table, based on the procedure, could have a dynamic number of columns : A|B|C|Price_1|Price_2|Price_...
- 2 years ago
Hello,
It should be added manually, since Power BI won't know which columns to add and it won't add by default.
- 2 years ago
Hi Anonymous
Unfortunetly No. You have to add it manually.
you can apply pivot column.In that case in auto refresh other pivot whih are added later on will be added part of a pivot.
Steps:
Go to power query
select your A|B|C| and go to transform> Pivot other columns
save and close.
Try to add in your Matrix visual any way you want it. but it auto fetches the newly added columns.
I hope I answered your question!
Idrissshatila
2 years agoSuper User
Hello,
It should be added manually, since Power BI won't know which columns to add and it won't add by default.