Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Relative Date Slicer "Include Today" Switches Back On

Hi,

I have an issue that keeps cropping up using the relative date slicer. Where "Include Today" keeps turning back on when being disabled and the slicer copied across pages and in Sync.

 

 


Todays date is 11/02/2022 (02/11/2022 for USA)

I have a relative data slicer, I have disabled "Include Today" as per below.

xuxxay88_0-1644593578343.png
I've set the slicer to "This - Day" (Doesn't matter if it's this month etc) then copied the visual across pages and enabled Sync.

Step 1 - On Page 1:

xuxxay88_1-1644594071106.png

 

Step 2 - On Page 2: CORRECT

xuxxay88_2-1644594095899.png

Step 3 - On Page 1: Changing to Last 1 Day - CORRECT

xuxxay88_3-1644594157737.png

 

Step 4 - On Page 2: It is mirrored from Page 1 - CORRECT

xuxxay88_4-1644594207008.png


Step 5 - On Page 1:  Switch back to "This - Day"

xuxxay88_5-1644594249881.png

 

Step 6 - On Page 2:  Mirrored - CORRECT

xuxxay88_6-1644594277425.png

 

Step 7 - On Page 2: If I stay on Page 2 and switch to "Last 1 Day" - INCORRECT It's showing Todays Date.

xuxxay88_7-1644594322938.png

 

Step 8 - On Page 2: If I switch back to "This - Day" the date remains the same and shows today as it should.

xuxxay88_8-1644594443695.png

 

Step 9 - On Page 1: If I switch to "Last 1 Day" - INCORRECT It's turned "Include Today" back on, on all pages.

xuxxay88_9-1644594534680.png

 

This issue carries over onto the Power BI service once published and it turns itself back on.

I believe it should remain off, so when you want to view Last 1 Day in isolation, it shows yesterdays date and This - Day should show todays date.

Am I missing something?

 

Thanks,

 

 

Status: Accepted

Hi,

I have reported this issue internally, ICM: 289238779

 

I will update here once I get any information.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

Comments
v-robertq-msft
Community Support
Status changed to: Investigating

Hi, 

What do you mean by “Page 2: It is mirrored from Page 1 ”? Are you using the page filter or the report filter as the relative date filter?

 

Would you like to post a download link of the pbix file with this issue without the sensitive data if it’s possible and we can help you to check if it’s an existing issue in the Power BI?

 

It will be very helpful if you can post the download link of the video that can show the reproducing steps of this issue.

 

I also suggest you to make sure you have updated to the latest version of the Power BI desktop.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

xuxxay88
Helper I

Hi,

Thanks for the response.

Apologies, by "Mirrored" I mean that the result of the slicer/setting of the slicer that has been changed by the user on Page 1 is also reflected on Page 2 - as you would expect if the "Sync" option has been selected when copying to a new page.

I am using the relative data slicer - not the page filter.

I am using the latest version of Power BI.

Please see attached example file, it's just a date table with 2 pages and a Relative Date Slicer on each page. 

https://wetransfer.com/downloads/8d6e37fdbbac78c15724d83fb9fc447b20220214084855/47931bbd22fd636c33cf...

v-robertq-msft
Community Support
Status changed to: Accepted

Hi,

I have reported this issue internally, ICM: 289238779

 

I will update here once I get any information.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

xuxxay88
Helper I

Thank you!

v-robertq-msft
Community Support

Hi,

I’ve got this message from pg: This issue is expected to be fixed in around 3/18

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

xuxxay88
Helper I

Amazing, thank you very much.

jim0000000000
New Member

Was there ever a resolution to this? I am still experiencing this issue.

xuxxay88
Helper I

No issues from me. Need to make sure you've got the switch in the slicer options configured correctly and republish the report.