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

Line and clustered column chart not display the correct value

Why the value is different (graph & table).

the value should be 44.32% instead of 144.32%( every value of on the graph will be added 100%+correct value%)

help me to solve it..

 

p/s: im using new measure - time intelligence to calculate YOY (growth rate).

PowerBI issue1.jpeg

6 REPLIES 6
Super User
Super User

Re: Line and clustered column chart not display the correct value

most likely different filter context - if you copy the chart and convert it to table visual, are the values correct then?

aizamkamadin Frequent Visitor
Frequent Visitor

Re: Line and clustered column chart not display the correct value

i've copied the graph and convert it to table...that's the result...different value..

and i'm not filter anything..

Community Support Team
Community Support Team

Re: Line and clustered column chart not display the correct value

Hi aizamkamadin,

 

Could you show the measure formula of GrouthRateGo?

 

Regards,

Jimmy Tao

aizamkamadin Frequent Visitor
Frequent Visitor

Re: Line and clustered column chart not display the correct value

GrowthRate.GO =

VAR __PREV_YEAR =
CALCULATE(
SUM('GDP'[Gross_Output]),
DATEADD('GDP'[Census_Year].[Date], -5, YEAR)
)
RETURN
DIVIDE(SUM('GDP'[Gross_Output]) - __PREV_YEAR, __PREV_YEAR)

Community Support Team
Community Support Team

Re: Line and clustered column chart not display the correct value

Hi aizamkamadin, 

 

Make sure that you have put same columns in both line chart and table chart.

 

Regards,

Jimmy Tao

aizamkamadin Frequent Visitor
Frequent Visitor

Re: Line and clustered column chart not display the correct value

yeah..both chart are using same column...