undefined

[nagarjunakan]

Hi Team ,

How to do this kind of slicers  please help me.

Thanks in Advance 

[Anonymous · Accepted solution]

Hi @nagarjunakan ,

I didn't find the visual, but I made two slicers to achieve the effect you want.

1.Create a calendar table and there's no relationship between the calendar table and the main table.

Calendar = CALENDAR(MIN('MainTable'[Date]),TODAY())

2.Create a table with categories by entering data.

3.Create the measure.

FilteredValue =
VAR nocustom =
    SWITCH (
        SELECTEDVALUE ( 'Table (2)'[Category] ),
        "Last 7 days",
            CALCULATE (
                SUM ( MainTable[Value] ),
                DATESINPERIOD ( 'MainTable'[Date], TODAY (), -7, DAY )
            ),
        "Last 14 days",
            CALCULATE (
                SUM ( MainTable[Value] ),
                DATESINPERIOD ( 'MainTable'[Date], TODAY (), -14, DAY )
            ),
        "Last 31 days",
            CALCULATE (
                SUM ( MainTable[Value] ),
                DATESINPERIOD ( 'MainTable'[Date], TODAY (), -31, DAY )
            )
    )
RETURN
    IF (
        SELECTEDVALUE ( 'Table (2)'[Category] ) = "Custom",
        CALCULATE (
            SUM ( MainTable[Value] ),
            FILTER (
                'MainTable',
                [Date] >= MIN ( 'Calendar'[Date] )
                    && [Date] <= MAX ( 'Calendar'[Date] )
            )
        ),
        nocustom
    )

You can check more details from here.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vanessafvg]

what is the context to this?  you have given very little information here if you use the filtering capability in power bi you should be able to do achieve this

see here for more information, and if you have a specific issue that you are struggling with please provide more information.

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-filter-types

[nagarjunakan]

Hi Vaness,

Thanks for ur help,

Actually i need start date and start time, End date and End Time in one slicer i need this kind of Format in one visual

[amitchandak]

@nagarjunakan , refer if this blog can help

https://community.powerbi.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-days-last-3...