Key Influencers reference line does not match with increase value

[PANDAmonium]

Hi all,

For the Key Influencers visual, the Reference Line is not matching with what the values it's saying for the trend. Sometimes the reference line would show a positive trend, but it was state a negative trend. I can't post the original report, but I tried to narrow down the issue and simplify it as much as possible and still couldn't figure out the cause.

I reproduced the issue with the table below. Comparing X to itself should yield a slope of 1; however, the results were always different no matter how I changed the values or how I configured the visual or fields. This results in saying "X goes down 1.07" as "the average of X increases by .96"

Date	X
2018-11	39.500
2018-12	39.600
2019-01	40.200
2019-02	40.600
2019-03	40.900
2019-04	41.600
2019-05	42.900

I'm not comparing the value to itself in my actual report, but hopefully understanding and knowing how to fix the issue in this simplified version will help me fix the issue with the visual in my actual report.

Thank you in advance!

[martinmoldrup]

I have the same issue. The link Lin is providing does not provide any resolution on the issue. 

[v-lili6-msft]

hi @PANDAmonium 

This seems a particular kind of computational logic, I would suggest you have a look at the document:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

Regards,

Lin

[PANDAmonium]

Actually, that example I gave earlier will result in saying that the X goes up 1.11 as the average of X goes up by 1.9 which is still incorrect. It was converting X to whole number earlier so I changed that to type decimal.