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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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


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


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


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


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

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.