Cascading Parameters in Report Builder 3.0 working with a Model

I'm working with and I am limited to a reporting model.
I would like to make my available parameter drop down values dependent upon the selection in another parameter.  
For instance if the first parameter is State and the user selects Texas, then the next parameter should only drop down available categories associated with Texas.  Instead, it is currently displaying a drop down of all categories contained in the model.  

I have found lots of web references to doing this outside of a model, but I'm limited to a model.

I have created three datasets
(1) Report fields
(2) States
(3) Categories

I created a parameter for state and set available fields to the state dataset.  
I created a parameter for category and set available fields to the categories dataset.  

Now I just don't know how to properly link the state and category parameters together in Report Builder 3.0.

Any suggestions are greatly appreciated.
Who is Participating?
lcohanConnect With a Mentor Database AnalystCommented:
"Lesson 4: Adding Cascading Parameters (Report Builder 2.0)"

"How to: Add Cascading Parameters to a Report (Report Builder 3.0 and SSRS)"
jaisy99Author Commented:
I should have included more detail.  I'm working with the reporting model and the query designer.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.