Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.