Forum Discussion
Visual not working In Power BI Service if I used Power Power BI dataset, works fine in PBI desktop
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.
3 Replies
- lbendlin
Super User
Now if I change my attendance filter, corresponding table not filteringHow do you know that? What other filters are impacting your visual?
- sd_parekhHelper I
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
- lbendlin
Super User
Hover over tthe filter icon for the visual to see the definitive list of filters at play. Check for interaction inhibitors.