Need Help in Passing Dynamic parameters in main dataset

Koritala 

Since you mentioned your data source is Amazon Redshift, I am assuming you are using "Get Data" experience in Paginated reports. 

If yes then I would suggest you to first 

1. Connect to Redshift with the Power Query editor using the "Get Data" experience in paginated reports.

2. Create a table by pulling the data from redshift view

3. Create a m parameter (to apply filter on your view) with some default value

4. Filter the table you created in step 2 using the parameter you created in step 3

Then load the data into Paginated report builder.

Then in Report builder,

1. create a parameter

2. Bind the parameter to the table, steps are here: https://learn.microsoft.com/en-us/power-bi/paginated-reports/report-builder/connect-snowflake-databricks-power-query-online#how-to-bind-parameters

This way, you will be able to achive the desired output.

Also, there is a great video from Guy in a Cube channel, where they explained all the steps 

https://www.youtube.com/watch?v=OQKgnJkjJDI

I followed these steps in my reports and it is working fine.

Hope this helps

Connect on LinkedIn

Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!