Forum Discussion
aoncirto
6 years agoFrequent Visitor
Error from dynamic data in chart
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...
amitchandak
6 years agoSuper User
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-bi-and-power-query/
https://community.powerbi.com/t5/Desktop/Dynamic-column-name-from-its-value/td-p/189442
- aoncirto6 years agoFrequent Visitor
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