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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Chris123Terr
Frequent Visitor

How to update the filter based on another filter?

Hi, I have this problem.
I have one slicer per year and another slicer per month. Years before 2016 are through December, but 2016 only has through October.
So when I select in the slicer
"2014" and "December" everything works perfect, however, when I select 2016, the month gets stuck and shows me nothing because there is no December 2016.

Slicer by year

Chris123Terr_0-1675874735030.png

Slicer by month

Chris123Terr_1-1675874748031.png

Result:

Chris123Terr_2-1675874784879.png

when i change to 2016

 

Chris123Terr_8-1675874937773.png

The month is stuck in December.
It does not show me anything because in December there is no data for 2016

Chris123Terr_5-1675874852049.png

 

 

 

1 ACCEPTED SOLUTION
onurbmiguel_
Super User
Super User

Hello 

 

My sugestion : 

 

Use the date slicer like this: 

onurbmiguel__2-1675876889648.png

 

onurbmiguel__1-1675876855909.png

 

the other sugetion is that when you change the year the user need to uncheck the month. 

 

Best regards

Bruno Costa | Solution Supplier

 

Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

Take a look at the blog: PBI Portugal 

wp-1586527108426

 

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


View solution in original post

1 REPLY 1
onurbmiguel_
Super User
Super User

Hello 

 

My sugestion : 

 

Use the date slicer like this: 

onurbmiguel__2-1675876889648.png

 

onurbmiguel__1-1675876855909.png

 

the other sugetion is that when you change the year the user need to uncheck the month. 

 

Best regards

Bruno Costa | Solution Supplier

 

Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

Take a look at the blog: PBI Portugal 

wp-1586527108426

 

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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