Forum Discussion
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_3|...|Price_n.
Since I'm using in Power BI a table visual to show informations based on those prices, I need to show dynamically in the table visual as much as prices that I have in the table created from the stored procedure.
Is there a solution to adjust dynamically the table visual?
Thank you.
Hello,
It should be added manually, since Power BI won't know which columns to add and it won't add by default.
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!
2 Replies
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!
Hello,
It should be added manually, since Power BI won't know which columns to add and it won't add by default.