All About Multi Value Parameters in Power BI Paginated Report | Tips and Tricks in Paginated Reports

This video explains all about Multiple values parameters in Power BI Paginated reports. This is also applicable for On-Prem version of paginated reports.
Please subscribe my channel for more videos.
Power BI Report Server Playlist - • Power BI Report Server...
Power BI Training - • How to use Power BI De...

[@jenndokken7904]

How do you get the Parameter to default to select "All" in the case where there is more than one value and to select the available value if there is only one?

[@HariBI]

You may need to handle in query level

[@linojohn-e4y]

I appreciate your video. Please let me know if you can. How can we Replace data in single inverted Comma ' in the default parameters

[@HariBI]

Can you share an example? What is the input value?

[@linojohn-e4y]

@@HariBI Example : I have 2 Dataset for parameter to work with cascading 1st One Doctor's Name and 2nd one is the Oncologist Name: = "SELECT DISTINCT ""AC_DC"".RPT_REFERREDPATIENTLIST.""DimDoctorID"", Replace(""AC_DC"".RPT_REFERREDPATIENTLIST.""DoctorFullName"",'''','\'')
AS ""DoctorFullName""
FROM ""AC_DC"".RPT_REFERREDPATIENTLIST
WHERE TO_DATE(""DerivedDate"") >= '" + Format(Parameters!p_StartDate.Value, "yyyy-MM-dd") + "'
AND TO_DATE(""DerivedDate"") ='" + Format(Parameters!p_StartDate.Value, "yyyy-MM-dd") + "'
AND TO_DATE(""DerivedDate"")

[@linojohn-e4y]

Is there any Solution do you have to help me out

[@krzysztoftalikowski9156]

Thanks for your video. I have a parameter with multiple values people type in. When I say in array =Parameters!ReportParameter1.Value(0) it displays first value. I need to change hardcoded array to (1) to display the second value from parameter. Can I build an array that displays in rows all values people type in parameter? =Parameters!ReportParameter1.Value() does not work. Your help would be appreciated.

[@HariBI]

Hi, please check - dataap.org/blog/2022/04/07/different-ways-to-print-multi-value-parameter-values-in-paginated-reports/

[@madanapalikishore7384]

Hi Hari,
Thank you for sharing!!
Could you please clear one doubt ?
We have published rdl which was developed by Power BI report builder. In the report execution time it was showing UTC but we need to show the report execution time as per user region dynamically . How we should handle this problem? It would be grateful if you help me.
Ex: If i am from India report execution time should show my time zone , if other person is from UK it should show his region time

[@sass520]

Hello sir i need to show space between bar in column chart with different values. Plz tell me how to achieve it.

[@shubhamkapse9088]

In Your Video "Values Of Parameter" Show All 4 Value Name ....But I Need 'All' Name Show Instead Of All 4 Value Name ,Can U Help Me?

[@shubhamkapse9088]

Because U Choose "Select All" Option So Need To Show "All" Name So Request To U Plz Solve My Problem