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
rassen
Frequent Visitor

Remove page filter but keeping slicer filter for Date column ?

I'm having page visual for the current year but want to remove this filter for one visual that show yearly trend 

I figure that All and AllSELECTED work for the number side but how do I remove the filter for the Date column to present the value over an unfiltered period ?

 

Also if I want Slicers to keep working, I should use Removefilter to remove that specific page filter only, is this correct ?

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@rassen , remove interaction between the year slicer and this visual.

 

Otherwise, if you select one year and want more than one year then you need a slicer on an independent table

 

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

 

How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4

View solution in original post

Thanks
I do have an independent date table which is where I filter date for the page filter

 

Are you saying that I should move the page filter to a slicer so I can adjust interaction ?

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@rassen , remove interaction between the year slicer and this visual.

 

Otherwise, if you select one year and want more than one year then you need a slicer on an independent table

 

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

 

How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4

Thanks
I do have an independent date table which is where I filter date for the page filter

 

Are you saying that I should move the page filter to a slicer so I can adjust interaction ?

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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