Use All Date Range and (Today() – 90 days) in the Filters on this visual(In the Same Time)

[nanojau]

Hello community,

I working in the Power BI Report and I would like to Set as Default Date in Slicer. Follow below example:

I want to bring Filters on this visual with(Today() – 90 days) when I open the report in this range and start with default. The Date Slicer cannot be locked(affected by the Filters on this visual) in the same range (Today() – 90 days), but yes showing all date range and inactive the Filters on visual page like the picture above:

Thanks,

[v-alq-msft · Accepted solution]

Hi, @nanojau 

Based on your description, It is unsupported to show all date range and inactive the filters on the visual page on the same time. When visual level filters are set, the date range of slicer is confirmed. As a workaround, you may use bookmark. 

When you create a bookmark, the following elements are saved with the bookmark:

• The current page
• Filters
• Slicers, including slicer type (for example, dropdown or list) and slicer state
• Visual selection state (such as cross-highlight filters)
• Sort order
• Drill location
• Visibility of an object (by using the Selection pane)
• The focus or Spotlight modes of any visible object

For further information, you may refer to the following link.

https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

Best Regards

Allan

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

[nanojau]

Thanks for your contribution Allan, Yes Bookmarks appear to be the better solution. I implemented Bookmarks with workaround to solve this issue, but our report user's would like to do it using Slicer only. I sent a improvement to Microsoft Ideas to upload the next version of Power BI with a smart solution for this step. Thanks,