Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Thanks,
i tried it but works only with certain type of direct query connection
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).
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.