Forum Discussion

JustinTime's avatar
JustinTime
Regular Visitor
8 years ago

KPI goal based on date slicer

Hi All,

 

I'm fairly new to Power BI and I'm hoping that I can find some help here.

 

Objective:

KPI Target Value to as show prior period based on the selection in my date slicer.

 

For example my Table[Date] field is set to 7 days, selected through a slicer. I'd like the target to the previous 7 days (or change based on the slicer selection). 

 

 

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    Hi JustinTime,

     

    You could create a measure to calculate the target value of previous 7 days with DATEADD function.

     

     

    If you still need help, please share some data sample and your expected output.

     

    Best Regards,

    Cherry

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    Hi JustinTime,

     

    Have you solved your problem?

     

    If you have solved, could you please share the solution or accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    Best  Regards,

    Cherry