Forum Discussion
Helper Ioverwriting default filter selection with new filter values using query filter parameter URL
Hi , Raki39
According to your description, the filter URL is the result of adding a filter to the visit page, because your previous page was filtered by 2020, and then you added a filter to the URL is 2021, at this time there is no 2021 on the basis of 2020 filtering, so this is a normal phenomenon. For your needs, I recommend that you set the selection of the original report slicer to not select, and then use the filter URL function to achieve your needs.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Community SupportHi, Raki39
According to the screenshot and description you provided, I think the reason why the filter of your "Fiscal Year" field does not show the data filtering for 2022 and 2021 is that their dataset has been filtered by filters at other levels, resulting in only 7 pieces of data filtered at present, because the filters in Power BI are intersected, my suggestion is that you can try to remove the filter at other levels by eraser first and observe this "Fiscal Year" The filter of the field shows whether there is a change.
Types of filters in Power BI reports - Power BI | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Raki39Hi v-yueyunzh-msft ,
Thank you for the response. Sorry if my question is not clear.
Actually, I have a report X where user want to see the fiscal year filter to be defaulted to 2023 and prbllty to A,B,C (A,B,C,D are the columns values).
Now I have to navigate from a Dashboard(different application) to this report X using query parameter URL. We are passing the parameter values dynamically to the query parameter URL based on the dashboard selection.
For example, if I 2020 data was select in the dashboard, then 2020 will be passed as parameter to the report and the same filter selection shd be show in the navigated report i.e 2020. But in this case, due to the default selection ( 2022) the new filter is unable to overwrite the existing filter selection thuogh it is showing in the filter value but without selection.
Is there anyway that I can clear the default selection dynamically before passing the query parameter or can overwrite the default value.
Thanks,Rakesh
- v-yueyunzh-msft
Hi , Raki39
According to your description, the filter URL is the result of adding a filter to the visit page, because your previous page was filtered by 2020, and then you added a filter to the URL is 2021, at this time there is no 2021 on the basis of 2020 filtering, so this is a normal phenomenon. For your needs, I recommend that you set the selection of the original report slicer to not select, and then use the filter URL function to achieve your needs.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly