cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Gerard Regular Visitor
Regular Visitor

Relative Date not showing in Slicer visualization ... (Power BI service)

I have a date field, which contains all dates... If I drop it onto a report, and set the visualisation to slicer, the only options I get from the drop down are 

"Between"

"Before"

"After"

"List"

"Dropdown"

 

(all of which work fine/as expected)

 

I was expecting to see "Relative"... what am I doing wrong?

 

(This post seems to indicate that it should be possible)

Thanks,
Ger

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Relative Date not showing in Slicer visualization ... (Power BI service)

Hi @Gerard,

 

That is too bad. Indeed, there is a workaround. I just found it minutes agoSmiley Very Happy. We can use "Page level filters" or "Report level filters". Have a look at the picture please.

Relative Date not showing in Slicer visualization.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
11 REPLIES 11
Community Support Team
Community Support Team

Re: Relative Date not showing in Slicer visualization ... (Power BI service)

Hi @Gerard

 

The “Relative” isn’t in Power BI Service by now. It’s a preview feature of May release of Desktop. You could reference here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/

 

There is a workaround. Change the slicer to "Relative" in Desktop, then publish to Service. It will work. Please have a try.

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Gerard Regular Visitor
Regular Visitor

Re: Relative Date not showing in Slicer visualization ... (Power BI service)

Thanks for the response @v-jiascu-msft

 

I was hoping you wouldnt say that Smiley Very HappySmiley Very HappySmiley Very Happy

 

To be honest, I have my entire set of dashboards/reports done through Power BI Service which was a hell of a lot of work, and I dont want to start using Power BI Desktop now as it would be too much of a change. 

 

Any idea when relative dates will be available in Power BI Service???? I need it really really badly. Is it on the backlog?

 

Thanks again,

Ger

Community Support Team
Community Support Team

Re: Relative Date not showing in Slicer visualization ... (Power BI service)

Hi @Gerard,

 

That is too bad. Indeed, there is a workaround. I just found it minutes agoSmiley Very Happy. We can use "Page level filters" or "Report level filters". Have a look at the picture please.

Relative Date not showing in Slicer visualization.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Relative Date not showing in Slicer visualization ... (Power BI service)

The "Relative" will come after the preview phase. Thank you for patience.

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Gerard Regular Visitor
Regular Visitor

Re: Relative Date not showing in Slicer visualization ... (Power BI service)

@v-jiascu-msft 

 

Thanks for your patience. That would work... however, on my Power BI Service instance, for the page or report level filtering, I only get an "Advanced filter" or "Basic filter" option... there is no option for "relative". Am I doing something wrong?

 

Ger

Community Support Team
Community Support Team

Re: Relative Date not showing in Slicer visualization ... (Power BI service)

@Gerard

 

Hi Ger,

 

Only date column has that option. Please check it out. I have tested continuous and non-continuous dates. Both work fine.

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Gerard Regular Visitor
Regular Visitor

Re: Relative Date not showing in Slicer visualization ... (Power BI service)

@v-jiascu-msft

 

Hi Dale, I'm really sorry. Still not seeing Relative Date filter. I'm must be missing something obvious. In an attempt to simulate what you have in your screenshot, this is all I have done.

* 1 report

* 1 table visualisation

* 1 column in the table called "Planned Delivery Date"

* Nothing else on the report. 

 

* With the table visualisation selected (or not), I drag the planned Delivery date field onto the page level filter (or report level filter).

* Both reading view and edit view are only showing me Advanced and Basic filter. See image below.... thanks again for your patience.

 

Filtering.png

 

Can you explain in words what you are doing. Not entirely sure what you mean by "Only date column has that option." Do I need to setup my data model differently?

Gerard Regular Visitor
Regular Visitor

Re: Relative Date not showing in Slicer visualization ... (Power BI service)

@v-jiascu-msf... Sorry for pestering you Dale... you do great work here... this would be a really useful workaround for me, but I just cant figure out what you are doing from the screenshots. Can you review my steps in my last post and let me know what I am doing wrong...? 

 

Thanks Dale,

Ger

 

Community Support Team
Community Support Team

Re: Relative Date not showing in Slicer visualization ... (Power BI service)

@Gerard

 

Hi Ger,

 

No problem. I will be very glad if I can help. Just a little busy. You connect the dataset in Service. So we can't manipulate it. Could you please check the source if data type of the column is "Date"? That could be the cause.

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.