Forum Discussion

vdf's avatar
vdf
Regular Visitor
6 years ago
Solved

Calculated field/Line and Stacked Column Chart

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"
 
  • 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

2 Replies

  • az38's avatar
    az38
    Community Champion

    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's avatar
      vdf
      Regular Visitor

      az38 

      Thank you so much, I'm just a beginner and your solution work like a treat. ğŸ˜€