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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Rince91
Helper I
Helper I

Data Slicer Bug- Relative date selection

Im building a report for a customer to review their closed service calls with my company. On the first page of the report i have a slicer that is synced across all pages of the report, the slicer is set to a relative date selection i.e. last 3 months. 

 

I have added data for these service calls going back to Jan 2017, however once i set the slicer to the previous 1 calendar month and then tried to expand that date to include more data; no further data turns up. For example i set it for the previous month March 2018, all the data came up and my report worked, then i selected the previous 3 months, the data did not update and still only showed March 2018. 

 

I've gone through all of my visuals removed all filters, added new visuals to test, checked all the data is still there (it is) but yet there is still only March 2018 data.

 

Any thoughts on what could be going wrong?

1 ACCEPTED SOLUTION
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @Rince91,

 

It works fine in my test.

1. What's the status showed in the following snapshot?

Data_Slicer_Bug_Relative_date_selection

2. Do you have any other filters or slicers?

3. Can you share your file? Just a little sample is needed.

 

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.

View solution in original post

2 REPLIES 2
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @Rince91,

 

It works fine in my test.

1. What's the status showed in the following snapshot?

Data_Slicer_Bug_Relative_date_selection

2. Do you have any other filters or slicers?

3. Can you share your file? Just a little sample is needed.

 

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.

@v-jiascu-msft

 

Hey, thanks for the advice fortunately i figured out that im an idiot. So here is how i "fixed" it. 

 

This is the slicer on my front cover/page:Query1.png

And here is how i had set up the slicer sync. As is glaringly obvious i hadn't ticked the filter buton on the front cover so this slicer didnt sync across all the report...

Query2.png

 

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.