Cascading Filters in Report Builder

[Anonymous]

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.

[v-lionel-msft]

Hi @Anonymous ,

You can refer to this:

Add Cascading Parameters to a Report (Report Builder and SSRS) 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.