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
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.
Did I answer your question? Mark my post as a solution! Kudos are also appreciated!
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.