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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ArktusStudio
New Member

Remove a page filter on an X-Axis

Hello, 

 

I'm facing an issue I can't manage to solve. 

 

I have a basic datamodel with two table : 

 

Calendar

Date (date

WorkingDay (boolean)

LastWorkingDay (Calculated-boolean)

 

Incident

Date (date)

Incident (int)

cntIncident (Measure to count incident by date)

 

Calendar and Incident are linked by Date. 

 

I have a report where all my visuals are filtered like this, with page-level filters : 

Date : Last 30 days

Working day = True 

LastWorkingDay = True

 

I would like to have one visual in this report to ignore the filter on "LastWorkingDay = True". 

For the Y-Axis, using cntIncident I managed this buy building the following measure : 

cntIncidentAll = CALCULATE(cntIncident, ALL('Calendar'[LastWorkingDay]))

 

However, as you can see in the image below, the X-Axis, using Date, remains filtered and I do not receive the expected results. 

Is there any way to solve this ? 

 

ArktusStudio_0-1663323016933.png

 

 

1 REPLY 1
Greg_Deckler
Super User
Super User

@ArktusStudio Unfortunately you can't override or ignore page level filters. You are going to need to move to using visual filters instead.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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