Power KPI Matrix Help : Sparkline showing wrong trend

[atul9063]

Hi,

I have created KPI Matrix visual using below data set.

Date	Legend	CurrValue	Previous Value	Diffrence
11/30/2018	Moto	845	700	145
10/31/2018	Moto	411	133	278
11/30/2018	Nokia	845	600	245
10/31/2018	Nokia	411	133	278

As you can see in below chart,Sparkline showing wrong trend.Diffrence value is declined from October to November for both Noika and Moto,even then trend showing upward.I want to dispaly trend on basis of diffrence value.

[v-lili6-msft]

hi, @atul9063

In your sample data, for Legend is Moto, CurrValue is 845 and last CurrValue is 411, so sparkline is upward.

and here is a Power KPI Matrix tutorial files for you to refer to:

https://www.dropbox.com/s/dxp7orpmfvcg1n8/PowerKPIMatrix.pbix?dl=0

Best Regards,

Lin