Multiple choice with data import parameter

[Marco_Iac]

Hi,

i create the  parameter "idcompany" to filter data before import by the company ID.

I have company A, B and C.

I apply the parametr to a table column to filter data befor importing:

Through the parameter I can filter by single company before importing the data.

The problem is that whe i manage the parameter to limit the data to import i am able to filter from a drop list only one company at time for example import data of only company A or import data of only company B.

Is there a way to create a parameter that allows to choice if import data from only one company or from all company? A sort of multi check drop list

Thanks

[Marco_Iac]

Thanks,

i tried it but works only with certain type of direct query connection

[mahoneypat]

In #2, your users would enter a list of companies into the text parameter, not choose from a list.

Company A, Company C, Company F   for example.  

However, this article by Chris Webb shows that doing a multi-select parameter is possible with the new Dynamic M parameters feature (I haven't used it yet, but it looks straight forward).

Chris Webb's BI Blog: Handling Multi-select In Power BI Dynamic M Parameters Chris Webb's BI Blog (c...

Regards,

Pat

[mahoneypat]

Two ideas to try

1. Make multiple parameters and use some "or" logic in your Company filter step prior to getting the data

2. Enter the companies as a text string separated by a delimiter in a single parameter, then use Text.Split() to create a list from that.  You can then use List.Contains(parameterlist, ...  to keep only the companies in the list.

Regards,

Pat

[Marco_Iac]

Thanks for the tips, i have 100 company to pass in the parameter so solution 1 is hard to implement and use; on a list of few companys it work well.

I don't  understand well solution 2, can you please give me an example?

at the and i need to save the model as a template, so that end user will able to select from the drop list which company's data load (data of only one company or data of all company)

Thank