Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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_...
  • Idrissshatila's avatar
    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.

  • Uzi2019's avatar
    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!