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
ilyasss
Helper II
Helper II

Remove filter Page from one visual only

Hello guys, 

 

I hope you are well.  

 

Before using a slicer, I was wondering if it was possible to remove a Page filter from only one visual of the page and keeping it for the other visuals ? 

 

Many thanks for your help, 

 

9 REPLIES 9

Hi @ilyasss ,

that is currently not possible.

The filters follow a kind of inheritance hierarchy that cannot currently be interrupted. 

Unless in a DAX calculation.

 

Filter on all pages > Filter on this page > Filter on this visual

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


Thank for your responses. 

 

I've tried to use All to remove the page filter (month & Partially) it works partially. 

 

Indeed, on my report I use a month page filter. I removed the Page filter in my dax formula by using the ALL like this : 

 

= CALCULATE(Sales ,ALL('Date Table'[Month and Year])).
 
Thanks to this, the chart shows the sales for all the months for each year but I would like to filter showing only the last 6 months. I've tried this to check the logic : 
 
=
CALCULATE([Sales],
ALL('Date Table'[Month and Year]), FILTER('Date Table', DATESBETWEEN('Date Table'[Date],DATE(2019,11,1),TODAY())))
 
But it didn't work. Do you have an idea to solve this issue ? 
 
Many thanks for your help, 
 

@ilyasss 

 

You may also try measure below.

Measure =
CALCULATE (
    [Sales],
    ALL ( 'Date Table'[Month and Year] ),
    FILTER (
        ALL ( 'Date Table'[Date] ),
        DATEDIFF ( 'Date Table'[Date], TODAY (), MONTH ) < 6
    )
)

 

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello, 

 

Thank for your help. 

 

Unfortunately, both formulas don't work properly as you can see below. The results is same for all the period and it's not the last 6 months.

 

PBI forum.jpg

 

I don't understand where is the issue because when I do : 

 

CALCULATE([% Sales],
ALL('Date Table'[Month and Year]))

 

 

I have the correct results but not in the period I I want as you can see below  : 

 

PBI 2.jpg

 

Do you have idea where could be the issue ? 

 

Many thanks for your help, 

 

Hi @ilyasss ,

 

you can share the formula for 

[% Sales]

 

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


Hello @mwegener

 

The % Sales is a simple formula like X sales / Total Sales * 100. 

 

I tried with a simple formula like count and with the date as you see below : 

 

 

TEST = CALCULATE([Count Distinct Sales],
    ALL('Date Table'[Date]),
    DATESBETWEEN('Date Table'[Date],DATE(2019,11,1),TODAY())
)

 

 

And the result is : 

 

Annotation 2020-04-28 150904.jpg

 

So the 389 is the total distinct sales within the datesbetween but theere is no distribution by Month. I get the impression that this issue may come from the Calculate.  What do you think ? 

 

To bypass the issue, I created a slicer with the date > edit interaction to delete the interaction between the slicer and the chart > Visual filter to get the data for the last 6 months. 

 

Nevertheless, I'm really curious to know if there is  a way to fix this with a formula.  

 

Thank you for your help.

 

 

 

Hi @ilyasss ,

 

ALL ignores all filters regardless of where the filter (slicer) is placed.

DAX cannot differentiate between these filter levels. (Exception: ALLSELECTED)

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


Hi @ilyasss ,

 

try this.

 

=
CALCULATE (
    [Sales],
    ALL ( 'Date Table'[Month and Year] ),
    DATESBETWEEN ( 'Date Table'[Date], DATE ( 2019, 11, 1 ), TODAY () )
)
Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


az38
Community Champion
Community Champion

@ilyasss 

great question, but I do not any option like this without programming


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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