Creating Cascading Parameters in Power Bi Report Builder using shared Power Bi Dataset Connection

[Akircher]

I am new to Power Bi and Report builder. I am trying to make Cascading Parameters for paginated reports using shared Power Bi dataset. However, all of the videos I see are using  SQL datasets and use SQL statements instead of DAX. Is it possible to do cascading parameters with a Power BI datset? If so how can I do it and were can I find more information?

[saglamtimur · Accepted solution]

It is basically the same. I have recorded a short video showing same procedure with SSAS and DAX query. Hope it helps.

[con_ssrivastava]

Hi , The video is for 35 secs only and there was not information regarding about the mentioned topic.

Please help!

[saglamtimur]

Hi,

Moved to YouTube.

If my post solved your problem, mark my post as a solution to help others to quickly find it and also please give it a 👍

[VizKid]

Hello

Thanks for the Video, it helps tremendously

I have a requirment to create a Single Table in the Report using multiple fields from more than one Dim/Fact table using Power BI Dataset as source Data for Paginated Report.

Inn your Video you used one Dim table to generate base Query. How can we combine mutltiple field, If I create common dataset - would the Parameters work?

Thanks in advance...

[Akircher]

Thank you! This helped me a lot