Relative Date Slicer - unable to see between/before/etc in Power BI Service

[KellyDittmar]

I have a Power BI report which I have created against an SSAS Tabular cube in Power BI desktop. I am using the new relative date slicer all over in this report. When I publish it to the PowerBI.com service - the drop down arrow disappears so that I can no longer specify a between/before/after/etc range of dates to filter  on - rather I can only specify relative dates. 

The red box marks the arrow that I find disappears. 

It is true that if I go into edit mode in the service - then the drop down reappears and the user is able to select a date range from a few months ago or last year. However, I don't want my users (up to and including my Senior Leadership Team) to be required to edit the report whenever they want to slice thru it. 

Is it only me who is experincing this issue? Is there any known solution at this time? 

Thank you!

Kelly

[v-ljerr-msft]

Hi @KellyDittmar,

It is true that if I go into edit mode in the service - then the drop down reappears and the user is able to select a date range from a few months ago or last year. However, I don't want my users (up to and including my Senior Leadership Team) to be required to edit the report whenever they want to slice thru it. 

Is it only me who is experincing this issue? Is there any known solution at this time?

---

Currently, we can change the Slicer Type(List, Dropdown, Relative, Between etc) only in Edit mode. To improve Power BI on the feature, I would suggest you add it as an idea on Power BI Ideas. 

Regards

[GilbertQ]

Hi @KellyDittmar

The only thing that I can think of is to ensure that your Date data type is set to Date?

I know in the past you had to mark the Date table in SSAS so that Excel would recognize it correctly.

[KellyDittmar]

Thanks for that reminder!

I just double-checked. The datatype = Date. I also cconfirmed the table is marked as a date table (using the correct date column) as well. 

Kelly