Error from dynamic data in chart

[aoncirto]

Hello Everyone, 

I have little issue with excel and charts in PowerBI. I set dynamic column name like this and works fine: 

DynamicNameHeader= Table.ColumnNames(#"Promoted Headers"){2} (in Excel sheet is column name CW_25)

DynamicNameHeader= Table.ColumnNames(#"Promoted Headers"){1} (in Excel sheet is column name CW_24)

But, if i do chart compare from CW25 to CW24. After i change the column names to CW20 and CW21, PowerBi update data correct but the chart still looking for old data. Do you have any ideas how to fix it ?

Have a nice day 

Thank you

Tomáš

[amitchandak]

@aoncirto , refer for dynamic Column Header
https://www.youtube.com/watch?v=yEemVBiaTuk
https://www.goodly.co.in/dynamic-column-names-power-query/
https://www.thebiccountant.com/2018/07/04/efficiently-rename-column-names-with-a-function-in-power-b...
https://community.powerbi.com/t5/Desktop/Dynamic-column-name-from-its-value/td-p/189442

[aoncirto]

Hi @amitchandak 

Thank you for reply. But i dont have problem with that dynamic Column header, already set and works fine for me, but only in table form. When i create chart with these dynamic column i just received blank chart or white screen with error(missing data from old saved excel ). 

Thank you for your links, was helpfull for another case for me, not for this one. 

Have a nice day