Daily, Weekly, Month filter

[joshcomputer1]

I just need to know if this is possible before I start to build it.  I want to send the link out to a report to a customerand have an easy to use filter for daily, weekly, and monthly.  Once the user clicks the filter, the visuals (column chart, boxes, line charts) will switch the range to that interval (ex: daily will show the last thirty days, weekly, last 9 nine weeks, etc). Then the user can click within the chart and drill down further to the day level.  I have data to the hour so daily is very important.  

I have no issues getting this stuff to work with static data, but the timing mechanism and drill downs seems to be difficult to implement the way I want it to.  

[v-chuncz-msft · Accepted solution]

@joshcomputer1,

One way is to simply add calculated columns and separate slicers.

isDaily =
DATEDIFF ( Table1[date], MAX ( Table1[date] ), DAY ) < 30

isWeekly =
DATEDIFF ( Table1[date], MAX ( Table1[date] ), DAY )
    < 7 * 9

[Salvador]

Hi,

to add something to @v-chuncz-msft, I use this for datediffs (you'd only have to replace the column names): 

Collections Delay =

    SWITCH (

    TRUE ();

    Invoices[Collection Date] < Invoices[Overdue Date]; DATEDIFF ( Invoices[Collection Date];Invoices[Overdue Date]; DAY )* -1;

    Invoices[Collection Date] > Invoices[Overdue Date]; DATEDIFF ( Invoices[Overdue Date]; Invoices[Collection Date]; DAY );

    0)

This way, you can avoid the limitation to datediff that forces one date to be more recent than the other (Just in case you run into that issue).