Forum Discussion
Cascading Filters in Report Builder
Hello All,
Need help on the below scenario in Report Builder.
I have created 3 Report parameters in Power BI service Report Builder. Am using Power BI Dataset as a Datasource in Report Builder.
1st Parameter is Year, 2nd is Quarter and 3rd is Month.
--->If I select Year Parameter value like 2020 it should cascade the other 2 Parameters. I.e in Quarter Parameter I should see 2020 Q1, Q2, Q3, Q4 and in Month Parameter I should see all months of 2020 I.e from Jan to Dec.
--->If I filter Quarter Parameter to Q2 2020 then I should see Month Parameter Values as April, May, Jun.
Thanks.
1 Reply
- v-lionel-msft
Community Support
Hi Anonymous ,
You can refer to this:
Add Cascading Parameters to a Report (Report Builder and SSRS)
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.