Add new column automatically to the chart

[Anonymous]

Hello all,

I have an survey file in excel. I put it on sharepoint then connect to power bi. The problem is the excel file may has new column in the future based on the exact question on the survey. One question may have answer in multiple columns.  How to make the chart with new column data automatically merger with the chart that already been made before ?

For Example, I make the question 1 into a chart with option A and option B. Then next month, it get new option C. I want this option C automatically add to the question 1 chart.

[Anonymous]

Hello @Idrissshatila ,

First, thank you for your response.

So what you're saying that new column can't be added to visualization automatically, right ? Now, I understand that it needs manual intervention to do that.

What if we use pivot table ? is that possible ?

[Idrissshatila]

Hello @Anonymous ,

If it was a row value for a certain column then it would automatically appear when the report is refreshed, But a column can't be automatically added because Power Bi will Identify this as a new column and it won't use it automatically, You should add it .

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin