combine 2 columns as 1 slicer in Power BI Or add 2 columns to slicer value. (multiple value)

[Anonymous]

Hi,
I have problem about how to combine 2 columns as 1 slicer in Power BI. Or add 2 columns to slicer value. (multiple value).
So, let me explain first. I have 2 columns, StartDate and EndDate with the Data Type is Date. And I need only 1 slicer to choose both the Start and End Date (if I choose between layout on the slicer, I can fill the first field for StartDate and the second one to EndDate). Can anybody tell me how to create that slicer ?
Or maybe what I need to do first with these columns before I adding it to the slicer. Thank you

Maybe help to understand more, here's the picture

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You can make these two columns to one column with a new table.

Table 2 =
UNION (
    SELECTCOLUMNS ( 'Table', "Date", 'Table'[start] ),
    SELECTCOLUMNS ( 'Table', "Date", 'Table'[end] )
)

The new "Date" column can be used in the slicer. Then you can refer to this case:

https://community.powerbi.com/t5/Desktop/DAX-measures-based-on-MAX-and-MIN-dates-selected-in-the-Time/td-p/776468

[Ashish_Mathur]

Hi,

Since you have not shared the complete question, i guess a simple way would be to build a single column in the Query Editor with all dates using the following M function in the Query Editor.

{=Number.From('Date'[Start Date])..Number.From('Date'[End Date])}

[Anonymous]

Hi @Ashish_Mathur ,

I'm sorry but I don't understand yet. How to create it ?

I created new column with your syntax and I got error

Is my syntax correct ?

Thanks

[Ashish_Mathur]

Hi,

I edited my original reply.  Please try that revised formula in the Query Editor.