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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
hvan-user2
Frequent Visitor

Unable to filter a field in Visual Level Filter Section

I'm connecting SQL Server with PowerBI via Direct Query.
I have a Table in a report which gets data from a dimension and fact table with a one-to-many bidrectional relationship.

The issue is, in the 'Visual Level Filters' section, I'm not able to filter values for some of the fields from the dimension table.

 

filter.JPG

 

Any help would be appreciated.

 

Thanks.

1 REPLY 1
v-micsh-msft
Microsoft Employee
Microsoft Employee

Hi hvan-user2,

 

I just tested at my side, and didn't encounter the issue you mentioned. Connecting to SQL server Analysis Service with Direct Query.

16.PNG

I suspect this should be mostly related with the data type in your data model. Please take a try to enable Tracing in Power BI desktop, see if we could get any further helpful information from the trace log.

File -> Options & Settings -> Options->Global->Diagnostics, check the tracing

And upload the trace log into OneDrive, then post the shared link here.

Regards

 

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.