How to create cascading parameters in paginated reports using Power BI Datasets - Power BI

[@niaz9391]

Thanks Man, You saved my face in the company

[@PowerBIHowTo]

Glad I could help. Good luck!

[@monicanakka3824]

That measure part we need to add in the dataset ... is killing me since 3 days finally saw ur video and understood why the cascading thing is not working... thanks you so much

[@PowerBIHowTo]

Thanks for the feedback. Glad to hear it was helpful. Keep the feedback coming. Best!

[@emilymalkin270]

Thank you sir for such a clear and easy to understand explanation! Liked and subscribed! ❤

[@PowerBIHowTo]

Thanks for the sub! And amazing feedback. Mission accomplished. This is the actual reason for these videos. If it help only one person on the earth, I'm happy. Share this channel or any video with your network, and on social media so others can join and maybe get help from all these videos. I will continue on this journey. Thank you!

[@256amartin]

excellent excellent was driving me crazy until i saw this. I was able to get this process to work, in my case using Sales Territory and Territory Customer.

[@PowerBIHowTo]

Excellent! WOW - I love this feedback. Glad it was helpful. Best regards!

[@osamaasif9601]

Thank you so much sir

[@PowerBIHowTo]

So nice of you. Thanks a lot!

[@alexklaus2778]

Hello and thank you very much! I have a question. Why is it so important to have a measure inside the query? Is there a solution to achieve that without the measure?

[@PowerBIHowTo]

Hi there, Reason to add measure to show only those products that has sales otherwise it will list all the products. Yes, you can use it without the measure as well but you have to be careful, check out this video why adding measure is important. kzbin.info/www/bejne/mmGxdJKImd6mm7s Sorry audio is not great but you will get the point. Thanks!

[@DailySoapFunny]

Nice Video. I have one question here, if I want to select one customer and automatically all the products under him should be selected without asking i.e. "Select all" I want to make it as default for individual customer and generate a report for us. How can we achieve this?

[@PowerBIHowTo]

Hi Noor, Thanks for the feedback and watching the video. You can do this by setting the _Default Values_ for the parameter and select the option using _Get values from a query_ and create a dataset that will be filtered based on the selected parameter. Let me know if this is clear or need further details. Good luck!

[@jrazafindrabe5229]

Hi, How to include "ALL" or "SELECT ALL" in a Single Selection Parameters in Power Bi Builder Optimized by DAX (Not SQL)

[@PowerBIHowTo]

I guess it is duplicate comment from another paginated report video.

[@jrazafindrabe5229]

Yes. Just responded to the other comment

[@Ksapra93]

Hi Sir, I have one question - I have created cascading parameter like one is region and other is customer. So let’s say if customer has 10 entries for same region. The region name on parameter is repeating 10 times so how can i show distinct region on parameter. Please help.

[@Ksapra93]

Just to add on - I’m using Power BI Dataset.

[@PowerBIHowTo]

Hi Kunal, Try following query for _region_ parameter dataset, if it doesn't work share the query that you are currently using for _region_ parameter. _EVALUATE_ _SUMMARIZE(YourTable, YourTable[RegionColumn] )_ Thanks!

[@Ksapra93]

@@PowerBIHowTo Hi sir, It is not working properly as it is not referring to the payer name and showing all the regions. Please find below query which I was using before: EVALUATE SUMMARIZECOLUMNS (' CIOP_input_workcentre_ha_shipment_history' (region], 'crop_input _workcentre_na_shipment history' (net_value_with_tax), ESCustonDaxFilter (@cropinputworkcentrenashipment hi.storypayername, EqualroCondition, (crop_ input workcentre[na shipment _history) . Ipayer_namel,String))

[@Ksapra93]

When I only used Evaluate Summarize instead of Evaluate summarize column below error I was facing when I’m selecting region parameter: Query (1, 138) Function SUMMARIZE expects a column name as argument number 3.

[@sandeepreddy7687]

Very informative. Thanks for the video. Could you please make a video on Paginated reports parameter search option like here I've lot of customers and I would like to have search option is it possible Sir?

[@PowerBIHowTo]

Thanks, @Sandeep! Glad to hear that you find this video useful. Regarding search, when report paginated report is published in the service, you can type value in the parameters to search the value. Let me know if this is what you mean by search.

[@oscariglesias1268]

Hello, this video does not have the subtitles activated, and for its translation into Spanish it would be necessary. Thank you

[@PowerBIHowTo]

Hi @Oscar, Sorry I was not aware if I need to activate something to make it work but after your message I did this, let me know if it works. Thanks for your feedback. Best, P

[@oscariglesias1268]

@@PowerBIHowTo It does not work, and the rest of the videos do have the subtitle option activated

[@PowerBIHowTo]

@@oscariglesias1268 Sorry I never did anything different to the videos to activate it. Anyhow I will do some more research to understand how it all works. Thanks for reporting this. Best!