Forum Discussion

Jidiez's avatar
Jidiez
Regular Visitor
8 years ago
Solved

KPI Filtered

Hello all,

 

I have a report that analyses the number of costumers that come to my business, I made some KPI's that compares the number of costumers from a chosen day with the same day from the previous week. 

 

What I would like to do is that when I open the report I could see today's values compared with last week without haven to select the date of today in the timeline first.

 

Here is what I see when I open my report:

 

 

 

 

 

And this is how I need to filter the data to see today's analysis:

 

 

Is there any idea of how can I do it?

 

Thanks!

  • Jidiez,

     

    You could add an additional slicer by creating a calculated column, and select "Yes" by default.

    IsToday =
    IF ( Table1[Date] = TODAY (), "Yes", "No" )
    

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support

    Jidiez,

     

    You could add an additional slicer by creating a calculated column, and select "Yes" by default.

    IsToday =
    IF ( Table1[Date] = TODAY (), "Yes", "No" )