Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We have built the metrics in our report to default to current month by creating a measure for each as follows
Attendances Current Month =
VAR MaxDate = MAX(Outpatient_Appointments[Appointment_Date])
VAR TargetDate = EDATE(MaxDate,0)
VAR Month = MONTH(TargetDate)
VAR Year = YEAR(TargetDate)
RETURN
IF( [Filter Comparison]=1,
CALCULATE([Attendances],YEAR(Outpatient_Appointments[Appointment_Date])=Year,MONTH(Outpatient_Appointments[Appointment_Date])=Month),
[Attendances]
)
This means the measure shows the current month attendances, unless you select a different month/more months in the filters. However, if a user keeps selecting months in the filters until all of the months in the dataset are selected, then the whole page defaults back to show current month attendances rather than the full number of attendances in the dataset. This is confusing for users and I can't find a way to stop it doing so! Please help!
Hi @rubydickinson,
Please share the pbix file with us without any sensitive data.
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |