I have created Attendance Range table which has single field value ranging from 1 to 100.
I used this as a attendance range slicer.
I created following measure which uses Attendance range table and attandance table to filter attendance of students for different term in table visual. See below image
Attendance Filter =
VAR MinValue = MIN('Attendance Range'[Value])
VAR MaxValue = MAX('Attendance Range'[Value])
VAR CurrentMeasureValue = [% Present]
RETURN
IF (
CurrentMeasureValue >=MinValue && CurrentMeasureValue <= MaxValue,1,0
)
If I change attendance range, corresponding table shows me data for that attendance range in a table. Attendance range filter working well in Power BI Desktop. This report uses school centralised dataset.
Now School database is centralise database for all school. I published this database on PBI service and created same report using online Power BI dataset through direct query. Now if I change my attendance filter, corresponding table not filtering. check below image
Note: I am using Premium capacity workspace.
Data volume is less than 1000000 rows.
Any help should be appriciated.
Thanks.
Now if I change my attendance filter, corresponding table not filtering
How do you know that? What other filters are impacting your visual?
Hi,
Now if I change my attendance filter, corresponding table not filtering
How do you know that?
Please check below image.
Range is set to 0-50 but table still shows all values.
What other filters are impacting your visual?
I used following other filters. Which correctly filter the table. But Attendance range filter not working.
Thanks
Hover over tthe filter icon for the visual to see the definitive list of filters at play. Check for interaction inhibitors.