cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RaajeshKrish6
Frequent Visitor

How to clear a particular slicer when i click on another particular slicer and vice versa

Hi,

 

How to clear a particular slicer when i click on another particular slicer and vice versa

1 ACCEPTED SOLUTION

@RaajeshKrish6 , With help from Row , you need to have an independent table

 

UNION(
ROW("Type","YTD","Year", Year(Today()),
ROW("Type","PTD","Year",Year(Today()),

'ROW("Type","PTD","Year", Year(Today()) -1

))

 

I think these slicers should able to change with each other and you need to use values from

year in filter



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

4 REPLIES 4
amitchandak
Super User IV
Super User IV

@RaajeshKrish6 , If you want reset selected values, I doubt. But yes it can reduce the selected value. if they are part of the same table or you follow this video of using a measure from the common table as a visual level filter https://www.youtube.com/watch?v=cyOquvfhzNM

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hi Amit,

 

Thanks for the quick turnaround. What you saying is like cascading filter, that will applied by default when we create two slicers from same source. But my requirement is different. Let me explain. Always I will have data's in my system for current year - 1 (2020) and current year (2021). I want an option in Report page named PTD and YTD . I have already bought records for both years and i have a year column in each records as well. So when i select PTD i want both 2020 & 2021, and when i select YTD i need only 2021. how to achieve this.

@amitchandak 

 

Thanks for the quick turnaround. What you saying is like cascading filter, that will applied by default when we create two slicers from same source. But my requirement is different. Let me explain. Always I will have data's in my system for current year - 1 (2020) and current year (2021). I want an option in Report page named PTD and YTD . I have already bought records for both years and i have a year column in each records as well. So when i select PTD i want both 2020 & 2021, and when i select YTD i need only 2021. how to achieve this.

@RaajeshKrish6 , With help from Row , you need to have an independent table

 

UNION(
ROW("Type","YTD","Year", Year(Today()),
ROW("Type","PTD","Year",Year(Today()),

'ROW("Type","PTD","Year", Year(Today()) -1

))

 

I think these slicers should able to change with each other and you need to use values from

year in filter



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors