Date format with timeline

[Oredo]

Hello everyone,
I'm not sure if it is the place, but i stumbled upon this, while making dashboard with timelines, where i want to pull timeline selection into different cell using Cubeset and Cuberankedmember, but the problem is, that date formatting comes in as american standard (month/day/year), where my local time is as Europe standard (day/month/year), which all i get as a result is month of January upon switching months in timeline slicer.
Anyone else stumbled upon this behaviour and maybe could help me to get around this problem?

1.Can't seem to be able to attach mock-up spreadsheet to illustrate the issue, so i will create table and run powerpivot model:

Date	item
01/01/2018	Item1
01/02/2018	Item2

<tbody>
</tbody>

2. Create timeline from it.
3. Formulas used =CUBESET("ThisWorkbookDataModel", Timeline_Date, "Month") any cell in the worksheet
4. Used formula to get selected month/s : =IFERROR(CUBERANKEDMEMBER("ThisWorkbookDataModel",$cell reference of step 4$,ROW(Sheet1!A1)),"")
5. Copy down formula for 12 months.

Thanks for your help and apologise, if anything is unclear.

 

[dnorm]

this is just an idea, and i bet there is a better way; however try:

format cell on incoming as 'US' mm/dd/yyyy then use formula (where the date is found in a1) =Month(a1) in another cell and format that cell as 'custom' mmmm. then slicer to that result for monthly options