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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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