Retrieve a subset based on user selection

parry2kI don't think that will work in my case. Maybe I wasn't very clear on what I want to do. Basically, I created an histogram visual using Direct Query and based on this visual I want to select one or several IDs (on a slicer) which will then filter a line chart so that I can analyze my data on a more detailed level. The issue here is that I only need a subset of my large dataset to visualize my line chart, therefore I want to retrieve the subset of the IDs I selected to be able to get my visualization. My idea was then to use the selected IDs to filter the data in an SQL query and retrieve the subset as a result. Is that possible with Power BI desktop? Does your suggestion solve this problem? I'm pretty new to Power BI so if I didn't understand your approach and it actually solves my problem please let me know :)