Field parameters not dynamically changing visuals

[sivarajan21]

Hi,

I was trying to create a field parameter to dynamically change my visuals.

Please find attached sample dataset in below link:

Missing Calendar fixed_sol.pbix

Below is my parameter created in report page:

But my visuals are not filtered(changing) by parameter I have created.

Can you please guide me on this?

Please let me know if you need further info.

Thanks in advance

@Ahmedx  @lbendlin @Greg_Deckler @Ashish_Mathur @amitchandak @grantsamborn 

[amitchandak · Accepted solution]

@sivarajan21 , I added the date to the Target table and joined with the date, Joined the invoice table with a date.

Check the added page in file after signature

[sivarajan21]

Hi @amitchandak ,

As i have not received any response, I will accept this as a solution and close this query.

Thanks

[sivarajan21]

Hi @amitchandak ,

Thanks for your quick response sir!
This is an amazing solution! This perfectly filters the table. But one thing that confuses me was this parameter is not filtering out the stacked bar chart as shown below:

Please can you help me with this ?

Any lead would be greatly appreciated!

Please find the attached sample file

Missing Calendar fixed_sol (1).pbix

Please let me know if you need further info.

Thanks in advance