Custom Slicer with two calender date pickers and custom periods ?

[Anonymous]

Hi Team ,

Can we create this kind of slicer in power bi? 

1. From Date Picker 

2. To Date Picker Sperately and

3. When we click on custom then only it display calender pickers

Sample Snap

Thanks In Advance 

Siddanth

[amitchandak]

@Anonymous , If you need slicer you can have it like

https://community.powerbi.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-days-last-30/m-p/1284966#M561629

or

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115

For all month , week, day , qtr and year , refer these blogs. Use date table

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[Anonymous]

How can we create calculations for below custom calculations ?

[v-eqin-msft]

Hi @Anonymous ,

You could create a table for slicer then use SWITCH() function to match each value.

today =
IF ( MAX ( 'Table 2'[Date] ) = TODAY (), 1 )

this week =
IF (
    YEAR ( MAX ( 'Table 2'[Date] ) ) = YEAR ( TODAY () )
        && WEEKNUM ( MAX ( 'Table 2'[Date] ), 2 ) = WEEKNUM ( TODAY (), 2 ),
    1
)

this month =
IF (
    YEAR ( MAX ( 'Table 2'[Date] ) ) = YEAR ( TODAY () )
        && MONTH ( MAX ( 'Table 2'[Date] ) ) = MONTH ( TODAY () ),
    1
)

last month =
IF (
    YEAR ( MAX ( 'Table 2'[Date] ) ) = YEAR ( TODAY () )
        && MONTH ( MAX ( 'Table 2'[Date] ) )
            = MONTH ( TODAY () ) - 1,
    1
)

this quarter =
IF (
    YEAR ( MAX ( 'Table 2'[Date] ) ) = YEAR ( TODAY () )
        && QUARTER ( MAX ( 'Table 2'[Date] ) ) = QUARTER ( TODAY () ),
    1
)

last quarter =
IF (
    YEAR ( MAX ( 'Table 2'[Date] ) ) = YEAR ( TODAY () )
        && QUARTER ( MAX ( 'Table 2'[Date] ) )
            = QUARTER ( TODAY () ) - 1,
    1
)

this year =
IF ( YEAR ( MAX ( 'Table 2'[Date] ) ) = YEAR ( TODAY () ), 1 )

Measure =
SWITCH (
    SELECTEDVALUE ( ForSlicer[Period] ),
    "Today", [today],
    "This Week", [this week],
    "This Month", [this month],
    "Last Month", [last month],
    "This Quarter", [this quarter],
    "Last Quarter", [last quarter],
    "This Year", [this year]
)

After apply the measure to filter pane (set "is 1"),My final output looks like this:

Or you could use Button 

Here is the pbix file.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @v-eqin-msft ,

I've tried the same thing but it didn't work me (Previous Year measure). Attached is the pbix file

Here is the link :  https://1drv.ms/u/s!Au-aOkl1BoHuglWJsqvs_GgNx7vp?e=kHzgTu

Can you please hekp me out on these?

Thanks In Advance

Sid

[MFelix]

Hi @Anonymous,

This exact look and feel is not possible but the options are currently available when you add a date column to a slicer you have several options:

If you combine a custom button for the selection alonside with some bookmarks you can do a similar experience altough the look is not the same. 

[Anonymous]

Hi Felix,

Can we add date picker in slicer ?

Snap

Thanks,

Vasu.