KPI Card using year trend + last month outcome

[evalromf]

Hi, I am trying out new ways to present data in a monthy report. The graph that I'm interested in is the KPI Card, where I would like to present the trend line of last years outcome, together with the number for the last month outcome. And I cannot get that to work. Does anyone know if that is possible with using the KPI Card? Or if there is any other way to achive this? I am a bit reluctant do use customized graphs, as I need to export the report to .ppt. And that sees to be undoable to do when using graphs developed by others. I appreciate any feedback! //Eva-Lotta

[CheenuSing]

Hi @evalromf

KPI Card may not be able to give you the result you expect.  KPI Card works on reporting the KPI Indicator say Sales with Trend over a period of time. And lastly the taarget to compare the KPI Indicator over the trend line.

Also it is not possible to have two different axis or trend line with the single axis value.

Can you share some data and the output you wish to achieve.

Cheers

CheenuSing

[evalromf]

Hi,

Sorry for my late reply - it's not because I'm not interested anymore, it's due to vacations 🙂

What I want to achive is something like the picture below. I have all data available, but the last month outcome is in another source file.

If you have any suggestions on how to achive this, I'd be very grateful.

//Eva-Lotta