Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 Unfortunately you can't override or ignore page level filters. You are going to need to move to using visual filters instead.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |