Forum Discussion

sd_parekh's avatar
sd_parekh
Helper I
3 years ago

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

  • Now if I change my attendance filter, corresponding table not filtering

    How do you know that?  What other filters are impacting your visual?

    • sd_parekh's avatar
      sd_parekh
      Helper 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's avatar
        lbendlin
        Icon for Super User rankSuper User

        Hover over tthe filter icon for the visual to see the definitive list of filters at play.  Check for interaction inhibitors.