Add columns to a table visual dynamically

[Anonymous]

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.

[Idrissshatila · Accepted solution]

Hello,

It should be added manually, since Power BI won't know which columns to add and it won't add by default.

[Uzi2019 · Accepted solution]

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 · Accepted solution]

Hello,

It should be added manually, since Power BI won't know which columns to add and it won't add by default.