Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
sd_parekh
Helper I
Helper I

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.

sd_parekh_3-1677736077951.png

 

 

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. 

sd_parekh_0-1677734815321.png

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

sd_parekh_2-1677735942791.png

Note: I am using Premium capacity workspace.

Data volume is less than 1000000 rows.

 

Any help should be appriciated.

Thanks. 

 

 

3 REPLIES 3
lbendlin
Super User
Super User

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. 

sd_parekh_1-1678184652897.png

 

 

What other filters are impacting your visual?

I used following other filters. Which correctly filter the table. But Attendance range filter not working. 

sd_parekh_0-1678184558992.png

 

 

 

Thanks

 

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

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.