cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vdf Frequent Visitor
Frequent Visitor

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"
 
1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

Re: Calculated field/Line and Stacked Column Chart

@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


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

View solution in original post

2 REPLIES 2
Super User II
Super User II

Re: Calculated field/Line and Stacked Column Chart

@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


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

View solution in original post

vdf Frequent Visitor
Frequent Visitor

Re: Calculated field/Line and Stacked Column Chart

@az38 

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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors