Calculated field/Line and Stacked Column Chart

[vdf]

Hi,

I have a calculated field as a percentage

Response_rate = FORMAT(DIVIDE(SUM('table'[field1]),SUM('table'[field2])),"0.00%")

and would like to add this filed into a "Line and Stacked Column Chart", however for some reason I cannot add it, any ideas?

Thanks in advance,

"Any help and all help is very much appreciated"

[az38 · Accepted solution]

@vdf 

first, you dont need to format value as percentage in formula.

you could easy achieve this in format fielt Modeling ribbon

if it won't help, please share text of error 

do not hesitate to give a kudo to useful posts and mark solutions as solution

[vdf]

@az38 

Thank you so much, I'm just a beginner and your solution work like a treat. 😀