Is it possible to make charts work dynamically even when header changes?

[Keith011]

Hi there

Is it possible to make chart still work even when the header changes?

I have a table like below (Table A) and I manage to visualize it. But the column can some time be "What is your preferred color? or What color is this" etc etc. When the header changes, the chart (E.g., Pie Chart) will return blank because it only reads "What is your favorite color?"

Is it possible to tell the chart that regardless of the header name just visualize the data

Note : Table A looks as it is because i did an unpivot column to be able to visualize it. The original table looks like this :

Original Table

What is your favorite color?

red

red

blue

green

green

green

white

Table A

attribute	value
What is your favorite color?	red
What is your favorite color?	red
What is your favorite color?	blue
What is your favorite color?	green
What is your favorite color?	green
What is your favorite color?	green
What is your favorite color?	white

[Keith011 · Accepted solution]

I have come up with my own solution.

in the "original table" , i'll assign an index number to all the questions and filter the graph based on the index number. So in future, even if the column header (a.k.a the question changes), the graphs won't break even though the graph is not able to read the original question instead it will read the index number instead

[v-zhangti]

Hi, @Keith011 

Maybe you can try this.

At this point, the title change does not affect the view.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Keith011]

Hi @v-zhangti ,

Thanks for getting back to me.

Hmm the example that i gave only consist of 1 column of data, in actual scenario the table may have at least 5 to 10 columns of data. And if that happens, the solution that you suggested may not work right?

I want to tell the chart that : Pie Chart 1 read from the 1st column of table A, Pie Chart 2 read from the 2nd column of the table A, Pie Chart 3 read from the 3rd column of table A (regardless of what the header changes to, just visualize it in the chart). And the Chart title should also dynamically change depending on what the column header changes to whether its "What is your favourite color" or What is your preferred color" etc.

[Keith011]

any idea?