Forum Discussion
how to add date range filter
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
Hi,
I answered a question similar to this yesterday. You may download my PBI file from here.
Hope this helps.
5 Replies
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
hemingtHelper V
Hi Anonymous ,
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.
Could you please help to have a look and give your suggestion? Thank you very much!
- Ashish_Mathur
Super User
Hi,
Can the time stamps be removed or do you need them?
- Ashish_Mathur
Hi,
I answered a question similar to this yesterday. You may download my PBI file from here.
Hope this helps.