Forum Discussion
filter by multiple Sahrepoint choice column
Hello,
I create a report based on Sharepoint list data.
I want to filter by column "dział" but it is multiple choice column and in power bi it is shown as a "LIST". Can you help me to do that ?
I heard that I shoul use Power query but i really do not know how it shoul be used.
Hi, Anonymous
According to your description, you want to filter by column "dział" but it is multiple choice column and in power bi it is shown as a "LIST". When you connect to the data source, you can use Table.FromColumns, Table.FromList, List.Transform in Power Query to accomplish your purpose.
Related links:
Solved: Expand column containing list of records - Microsoft Fabric Community
Official Documentation: Table.FromList - PowerQuery M | Microsoft Learn
If this does not work, could you please share some sample data without sensitive information and expected output, feel free to ask anything about this.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
2 Replies
- amitchandak
Super User
Anonymous , Not very clear.
Refer if this can help
Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
https://medium.com/@amitchandak/power-bi-search-text-parts-in-text-ad2f9783ffa2The information you have provided is not making the problem clear to me. Can you please explain with an example.
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos. Hi, Anonymous
According to your description, you want to filter by column "dział" but it is multiple choice column and in power bi it is shown as a "LIST". When you connect to the data source, you can use Table.FromColumns, Table.FromList, List.Transform in Power Query to accomplish your purpose.
Related links:
Solved: Expand column containing list of records - Microsoft Fabric Community
Official Documentation: Table.FromList - PowerQuery M | Microsoft Learn
If this does not work, could you please share some sample data without sensitive information and expected output, feel free to ask anything about this.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
