Forum Discussion

adam_mac's avatar
adam_mac
Helper 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
Super 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

adam_mac's avatar
adam_mac
Helper I
5 years ago

As a work around i created a area chart showing MTD sales by day, placed behind the KPI card and decreased the transparency. Works just as well i think althought i couldnt find anything for conditional formating the colour of the graph to match the KPI card. 

 

Thanks for your help