Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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,
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
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 :
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
)
)
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.
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 :
Do you have idea where could be the issue ?
Many thanks for your help,
Hi @ilyasss ,
you can share the formula for
[% Sales]
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 :
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)
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 () )
)
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
104 | |
99 | |
97 | |
41 | |
38 |
User | Count |
---|---|
151 | |
123 | |
79 | |
73 | |
71 |