How to pass the visual selected values to report query dynamically

[VijayAntonyM]

Hi Team,

Good day.

Kindly help,

How to pass the selected values dynamically from visuals(tables, charts) as a parameters to data source queries,

Level 1: User needs to click on the Total Shipments column count below,

Level 2: Display the clicked Total Shipments count-2069 detail records into next page,

Kindly note, need to pass the some column values as parameters - Month-Year, Enterprise Account Number, Payer Account Number, Product using Manage Parameters option in power query editor

Kindly help

regards

M. Vijay Antony

[Anonymous]

Hi @VijayAntonyM ,

Selecting values in a report is an interaction and filtering of the data that has been loaded into the report. This filtering typically only affects the report or visualization you're currently viewing, and doesn't change the underlying data. Power Query is used to transform, clean, and prepare data before it is loaded into a report. Their query for the data is two different layers, so it's not possible to pass the selected values in the report into Power Query.

The workaround is load all the data into the report beforehand and then filtering it based on the selected values. This can cause your report to be too large, and you can purchase some Premium capacity.

Purchase the right Premium capacity based on your reports. 

How to configure workloads in Power BI Premium - Power BI | Microsoft Learn

Best regards,

Mengmeng Li

[danextian · Accepted solution]

Hi @VijayAntonyM 

That is not possible. The query editor affthe semantic model, but changes in the semantic model do not influence the query editor. To achieve dynamic filtering based on slicer selections, load the entire dataset into the data model and apply filtering logic using DAX measures. If you're using DirectQuery, slicer selections can dynamically adjust the queries sent to the underlying database. However, this occurs within the reporting layer and does not affect transformations in Power Query.