Forum Discussion

Rachel's avatar
Rachel
Frequent Visitor
10 years ago

KPI Visual Goal - Based off previous month's data

I'm having trouble with the Goal piece of the new KPI Visual.  The overview of the feature in the video simply created a goal based off the current month's count.  This doesn't really make sense.  I'm trying to set the goal to be based off a previous month's value.  But, as soon as I set the new measure, it's broken down by month (the trend axis for the visual).  This means the goal I set is only ever based off the current month's value, which is not a useful metric.  Is there a way to set the target goal based off another field already in the data that aggregates based on a previous month's data? 

 

Hope that makes sense.  I've tried everything I can think of, and no matter what formula I create, it will only set the goal based on the current month's data. 

6 Replies

  • Tsanka's avatar
    Tsanka
    Kudo Collector
    10 years ago

    I am using this visual. In my case the indicator is the current month revenue and the goal is a measure for previous month MTD revenue. The trend axis I use is the date hierarchy (Date-Year).

     

    This setup works okay for me, the only problem is when there is no data for the previous month. Then the visual displays blank, which is not correct as in my case  it should display the current month revenue.

     

    Hope that helps 

     

    • Rachel's avatar
      Rachel
      Frequent Visitor
      10 years ago

      That's helpful if the data is entered aggregated by row, looks like in this example the data has one line per month.  But my data is entered in one row per user per month.  I'm looking for a KPI based on the count of users for the month, and want to compare that to the count of users for the past month.  All the data is there, but it's not aggregated on a per month basis when I load it in, I feel like Power BI should be able to handle this and allow for aggregating within the report creation.   I need to have the individual data by row so I can add slicers to allow for the user to filter it based on differnt product categories, so aggregating it before uploading it won't make sense for my use case.

       

      • DanielClark's avatar
        DanielClark
        Helper II
        9 years ago

        Rachel,

         

        Did you get any further on this issue?

        I am just looking into a simillar data set and would like to try and utilise the data in a KPI; the closest I got was, as you described an new column/measure. That is the current and previous month calculation using the previousmonth function and summing the columns, then divide them and convert to percentage.

         

        Regards,