Forum Discussion

adam_mac's avatar
adam_mac
Icon for Helper I rankHelper I
5 years ago
Solved

KPI Visualization card not showing current month

Hi, i am trying to build a simple KPI viz that shows current months sales vs sales target.    The problem i am having is its not showing current month, instead it seems to be showing previous month...
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi adam_mac ,

     

    For your KPI visual, you will need to create another measure with just sales for your current month, e.g., January 2021.

    You can write a measure as follows:

    CurrSales = CALCULATE([CurrentMonthSales],

    FILTER(Finance_Sales, MONTH(Finance_Sales[PurchaseDate])= MONTH(TODAY()) && YEAR(Finance_Sales[PurchaseDate])=YEAR(TODAY())))

     

    Now move this measure to the Indicator section of your KPI visual.

     

    Thanks,

    Pragati

     

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

Hi adam_mac ,

 

For your KPI visual, you will need to create another measure with just sales for your current month, e.g., January 2021.

You can write a measure as follows:

CurrSales = CALCULATE([CurrentMonthSales],

FILTER(Finance_Sales, MONTH(Finance_Sales[PurchaseDate])= MONTH(TODAY()) && YEAR(Finance_Sales[PurchaseDate])=YEAR(TODAY())))

 

Now move this measure to the Indicator section of your KPI visual.

 

Thanks,

Pragati

 

adam_mac's avatar
adam_mac
Icon for Helper I rankHelper I
5 years ago

so that seems to have worked and i did the same formula for the targets also...however the problem is now that i am missing the graph behind the figures, any ideas how to get it back?

 

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    5 years ago

    Hi adam_mac ,

     

    The background area chart in a KPI visual only displays when you are showing a trend over time - this was the case earlier.

    But now you are just showing a single month metrics in time (current month), therefore the background area chart has disappeared in your KPI visual.

     

    Thanks,

    Pragati

    • adam_mac's avatar
      adam_mac
      Icon for Helper I rankHelper I
      5 years ago

      If we are showing the month, does this not count as a trend over time? 

      • Pragati11's avatar
        Pragati11
        Icon for Super User rankSuper User
        5 years ago

        HI adam_mac ,

         

        Your value is aggregated for that single month - so look at it as a single value for the whole month. It hasn't got different value for every single day in that month. It has got same value for every single day in the current month. Therefore no trend in this case.

         

        Thanks,

        Pragati