Forum Discussion

JLEmlet's avatar
JLEmlet
Regular Visitor
4 years ago

Dynamically change where statement from slicer selection

Hello - We're beginners at Power BI and are running into an interesting problem.  We have a table with over 5.9M rows.  We only need to display one customer at a time which brings the max rows to ab...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi JLEmlet 

I do not quite understand what you mean. As you said , you want to display one customer at a time, is customer a single column of values in your data source ? If yes , you can connect to SQL to load the data and then add a slicer with the field “customer” to filter one customer .

Original data :

Filter data :

Best Regard

Community Support Team _ Ailsa Tao

JLEmlet's avatar
JLEmlet
Regular Visitor
4 years ago

I'd rather be able to use DirectQuery since the underlying data updates every couple of minutes.  But there are nearly 5m rows and the server is an on-prem server and the PowerBI report is deployed in the cloud. So it takes about a minute for the query to run against the database.  But if the query ran only for the customer selected in the slicer, it would only be 10K rows or so per client returning in just a few seconds.  But that would require the slicer to be able to pass the selection into the DirectQuery.  Is that a possible solution?