Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

KPI visual show YTD or multiple months

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

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

     

    Thanks

    Raj

    • Anonymous's avatar
      Anonymous
      Not applicable

      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