KPI visual show YTD or multiple months

[Anonymous]

Hi,

I am hoping someone can help me return the YTD value (or multiple months) that are selected in a "Month" slicer to show up in the KPI visual?

Thanks

[Anonymous]

Can you please share more details? The above information is not giving full picture of the requirement.

Thanks

Raj

[Anonymous]

Hey Raj,

This is the data it is selecting:

 

And the resulting solution comes back as, which is just the latest month not the cumulative average:

So just selecting the last month, not the cumulative view. I think it might have something to do with the “Trend axis” that I am using? (here I am using a month column from the raw data)

Any help would be great. Thanks