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
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
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.