cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Date Filter format

Hello, Is there a way we can have two same Date filters on a single report page? I want to have one date filter in Relative format (Last 2 days) and other in Calendar format where I can select the dates from the calendar.

Currently, when I do this the report gets confused which date filter to consider. Any solutions?

8 REPLIES 8
Community Support
Community Support

Hi anki12,

 

"Currently, when I do this the report gets confused which date filter to consider. Any solutions?"

 

<--- Based on your description, you have two filters, one is slicer based off calendar format column and other is relative filter(to filter last 2 days), right? So what's your concern? Could you clarify more details about your requirment?

 

Regards,

Jimmy Tao

Super User II
Super User II

Hi there

Just so that I understand you want to have a relative date slicer for the last 2 days?
This will then mean that there are only 2 dates shown, and 2 dates available in the visuals?

If that is the case above the second filter will only show 2 available dates?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

So as you can see on the below image, I want both the Date visuals (which are in a different format) on the same report, if my user wants to see the data based on the last two days the Calendar date visual should be locked or disabled and vice versa.

 

They are on premium capacity and not PRO users. That is why they cannot see the option for changing the date filter from "Relative" to "Between"

 

DateVisual.PNGCapture.PNG

Hi @anki12

Unfortunately what you are trying to achieve cannot happen because you are trying to filter your data using 2 date filters. That is like saying I have 2 sets of car keys why can I not use both at the same time to open the car.

With regards to changing the filter from relative to between, in the properties, enable the toggle for Slicer Header, which will then enable the arrow to be shown as shown below

 

image.png

 

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Thank you for solving this doubt @GilbertQ.

I have enabled Slicer Header and can see it on Power BI Desktop(PBI pro user) but when I publish my report, the arrow is not visible for the users under premium capacity.

Hi there,

can you make sure that you have got the Visual headers Enabled on the Visuals?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@GilbertQ Yes both Slicer Header and Visual Header are enabled.

I see the eraser but not the arrow. I can only see this on Power BI service when I click on Edit Report as a PRO user but we do not have edit report access for our users under premium capacity

 

 

Pic1.PNG

 

Hi there

From your screenshot it does appear that the visual headers are disabled?

Also when in viewing mode the users will not be able to change any slicer elements.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors