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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.