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

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.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors