cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
hvan-user2 Frequent Visitor
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 New Contributor
New Contributor

Re: Unable to filter a field in Visual Level Filter Section

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
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 6 members 3,104 guests
Please welcome our newest community members: