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
RWRW
Helper III
Helper III

Year Slicer doesn't work well

Hi @all,

 

Hope Someone can help me. I have on table with 4 fields: id, equipment, date, matrix.

RWRW_1-1713678502251.png

I want to have 2 different slicers on the screen, one to show all the equipments I have and the other all the different years depending of the type of matrix is already set in the filters of the page. In this case the filter of the page by default is Swab

RWRW_2-1713678599347.png

When I add the first filter reagrding the equipment all ok. Then I add the second slicer regarding the year, date field has this structure

RWRW_3-1713678731776.png

so I select year. Until now all ok but when I go to the slicer the visual is showing 2021 and 2022 what it's wrong since the filter of the page is Matrix = SWAB and as the table is shown Swab is only in 2021.

 

In the year slicer when I click the filters of the visual are:

RWRW_0-1713679426588.png

The configuration is correct but it looks like matrix equal Swab is not filtering the data since display 2021 and 2022.

 

Why displays 2022? What do I need to do? I tried many differents things but no way, I changed the format of the date etc...but it doesn't work.

 

I hope someone has the response.

Thanks a lot in advance

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

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!

December 2024

A Year in Review - December 2024

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