Forum Discussion

Dom87326's avatar
Dom87326
Helper II
4 years ago
Solved

KPI Visualization does not sum the data YoY

Hello,     I'm trying to compare different time periods with Power BI KPI visuals and for that reason created following measures:      Purchases = SUM('Purchases'[Quantity]) Previous Purchases...
Need Help
  • aj1973's avatar
    aj1973
    4 years ago

    Hi Dom87326 

    Your Measure must be 

     

    Previous Purchases = CALCULATE ([Purchases] , SAMEPERIODLASTYEAR('Date'[Date])

     

  • aj1973's avatar
    aj1973
    4 years ago

    Dom87326 

    The filters are applied on the viusal level not the the whole page

    Try to CRTL / SELECT the 3 band chart and watch the card please

v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

Hi Dom87326 ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

 

Best Regards
Lucien