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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors