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?
"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?
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"
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
Did I answer your question? Mark my post as a solution!