Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

How to default to Select All in a Report Builder Parameter

I have created a Paginated Report Parameter that displays a list of Legal Entities and the user can choose one and refresh the report. I want it however to default to selecting ALL of them - but this does not seem possible?

 

Also - seocndary question - If ALL are selected I'd like it to say the word 'All' (or similar) in the textbox on the users screen, instead of showing the first Legal Entity even when they are ALL selected

1 ACCEPTED SOLUTION
DavisBI
Solution Specialist
Solution Specialist

Hi, @Anonymous ,

 

If you are using a relational database as a data source then you can do the trick in your SQL statement.

For example:

 

SELECT * FROM PRODUCT_TABLE
WHERE CASE WHEN PRODUCT_NAME="All" then "All" ELSE PRODUCT_NAME END IN @PRODUCT

 

Then, the default value of the parameter "@PRODUCT" can be set to "All" in the report builder, so that whenever the user running the report, the filter for PRODUCT will be ignored.

 

Mark this post as a solution if this helps, thanks!

View solution in original post

2 REPLIES 2
DavisBI
Solution Specialist
Solution Specialist

Hi, @Anonymous ,

 

If you are using a relational database as a data source then you can do the trick in your SQL statement.

For example:

 

SELECT * FROM PRODUCT_TABLE
WHERE CASE WHEN PRODUCT_NAME="All" then "All" ELSE PRODUCT_NAME END IN @PRODUCT

 

Then, the default value of the parameter "@PRODUCT" can be set to "All" in the report builder, so that whenever the user running the report, the filter for PRODUCT will be ignored.

 

Mark this post as a solution if this helps, thanks!

lbendlin
Super User
Super User

Have you considered adding a fake "All" legal entity row to your source data, and associate it with summarized data?  Alternatively you could create a calculated column or measure for this.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Kudoed Authors