Adding parameters with multiple selection

Power BI Paginated Reports
1

Please help with Paginated report. Report builder is powered by data from the power bi web dataset. The dataset is Azure Analysis Servers. I can’t manage to set all fields selected by default or the option to select the default “null” on one of the parameters. If the user would like to select data from this field, I want him to be able to select multiple options, not just one.

How to do it?

The “EAN” field is just the parameter it should be as a multiple choice filter with “all fields” selected by default Below is the dataset query that is in the report builder

DEFINE VAR __DS0Core = 
	SUMMARIZECOLUMNS(
		ROLLUPADDISSUBTOTAL(
			ROLLUPGROUP(
				'TableA'[Dodane przez],
				'TableA'[Kolekcja],
				'TableA'[Asortyment],
				'TableA'[Department],
				'TableA'[Grupa towarowa-kategoria],
				'TableA'[Płeć],
				'TableA'[Typ],
				'TableA'[Podtyp],
				'TableA'[Wejście],
				'TableA'[Sezon],
				'TableA'[Rodzaj pakowania],
				'TableA'[RepeatOrder],
				'TableA'[Nazwa modelu],
				'TableA'[EAN],
				'TableA'[Season]
			), "IsGrandTotalRowTotal"
		),
		"SumZaliczka__", CALCULATE(SUM('TableB'[Zaliczka %])),
		"SumIlość_dni_do_odroczenia", CALCULATE(SUM('TableB'[Ilość dni do odroczenia]))
	

EVALUATE
	__DS0Core
2

@Harris To set all fields selected by default in a paginated report, you need to add a default value to the parameter. In Report Builder, you can achieve this by doing the following:

  1. Open the report in Design view.
  2. In the Report Data pane, expand the Parameters folder and select the parameter you want to set the default value for.
  3. In the Properties pane, under the Default Values section, select Specify values.
  4. Click the Add button to add a default value.
  5. In the Value field, enter the value you want to set as the default. To select all fields by default, you can use an expression like =“ALL”.
  6. Click OK to save the default value.

To allow the user to select multiple options for the parameter, you need to set the parameter’s Multi-value property to True. In Report Builder, you can do this by following these steps:

  1. In the Report Data pane, select the parameter you want to allow multiple selections for.
  2. In the Properties pane, under the General section, set the Multi-value property to True.

To allow the user to select the default “null” option, you need to add an option to the parameter that represents the “null” value. In Report Builder, you can do this by following these steps:

  1. In the Report Data pane, select the parameter you want to add the “null” option to.
  2. In the Properties pane, under the Available Values section, select Get values from a query.
  3. Click the Query Designer button to open the query designer.
  4. Add a new column to the query that represents the “null” option. You can use an expression like =“NULL” to represent the “null” value.
  5. Set the Value field to the same expression you used for the Display field.
  6. Click OK to save the query.
  7. In the Report Data pane, under the Default Values section, select Specify values.
  8. Click the Add button to add a default value.
  9. In the Value field, enter the expression you used for the “null” option. For example, =“NULL”.
  10. Click OK to save the default value.

With these settings, the user should be able to select multiple options for the “EAN” field, with “all fields” selected by default, and a “null” option available.

1 Like
3

Thank you for your reply. Could you please send screenshots to the last point about adding NULL values, where and how to add it? I’ve tried many times, but it doesn’t work for me

4

Bumping this post for more visibility from our experts and users.

5

Hi @MohammedHuzefaBagwan,

I wanted to follow up with you and check if you had the chance to review the response and address the follow-up question related to your proposed solution.

Thank you for your valuable contribution to the community. It’s greatly appreciated.

6

Hi @Harris

We noticed that your inquiry was left unsolved for quite some time now.
Looks like your inquiry was out of the experts’ and users’ bounds.

If you were sure you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, your membership also comes with relevant resources that may help you with your Power BI education, so we advise that you check these resources as well.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!