how to add date range filter

[Anonymous]

Hi,

i have table has start date/time and end date/time filed. now i want to give date range filter to user so user can select start date and end date based on that data get filter.

pls guide how to add date range filter.

Thx

[Ashish_Mathur]

Hi,

Can the time stamps be removed or do you need them?

[Anonymous]

time stamp can be removed, i  just need to filter based on date.

[Ashish_Mathur · Accepted solution]

Hi,

I answered a question similar to this yesterday.  You may download my PBI file from here.

Hope this helps.

[v-shex-msft]

HI @Anonymous,

Power bi not support direct operation on date range which define by two columns.

You need to create a calculated table to store expand detail date and link to original table, then you simply use new data column as source of slicer to filter on date range.

Sample table formula:

Expand date table =
VAR _calendar =
    CALENDAR ( MIN ( Table[start] ), MAX ( Table[end] ) )
RETURN
    SELECTCOLUMNS (
        FILTER (
            CROSSJOIN ( Table, _calendar ),
            Table[start] <= [Date]
                && Table[end] >= [Date]
        ),
        "id", Table[unique ID],
        "Date", [Date]
    )

Build relationship based on 'id' column, then use new date column to create slicer to filter on original table.

Regards,

Xiaoxin Sheng

[hemingt]

Hi @v-shex-msft ,

I see your post when I searched in the forum and your answer may help me.

I want to apply filters from several columns(Project+Version+CyleName).

Please see my shared excel. https://1drv.ms/x/s!AsM9bO8zGUN6qnGmCaFm-w7WgYYL

add here is my original post.

https://community.powerbi.com/t5/Desktop/How-to-create-several-filters-which-should-applyed-several/...

Could you please help to have a look and give your suggestion? Thank you very much!