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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
TT77
Frequent Visitor

Unexpected filter behaviour

Please refer to the screenshots below.

 

  • So whenever I apply a Report Filter (first screenshot) the date slicer seems to automatically adjust itself to 5-5-2018 (unwanted behaviour).
  • This doesnt seem to happen when I apply the same filter "B" within the report itself (second screenshot). The date slicer doesnt change at all and stays at 4-06-2018.

Some users prefer to use the Report level filters and are confused by this inconsistent behaviour. Is there any way to fix this? 

 

Date.pngFilter within report.png

1 ACCEPTED SOLUTION
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @TT77

 

By my test, I'm afraid that there is no good way for us to fix this.

 

As a workaround, you could use Sync Slicers to replace report level filter.

 

sync slicer.PNG

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
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-piga-msft
Resident Rockstar
Resident Rockstar

Hi @TT77

 

By my test, I'm afraid that there is no good way for us to fix this.

 

As a workaround, you could use Sync Slicers to replace report level filter.

 

sync slicer.PNG

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for reply, unfortunately most of the Report Level Filters cannot be included within the report itself with Sync Slicers option enabled. Due to the lack of space and limited filter options.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.