Filter rows data

[Iceberg12]

Hello everyone, 

I have the following table:

Name	Code
Company A	"1", "2", "3","4","5"
Company B	"1", "2"
Company C	"1", "2", "3","4","5"
Company D	"1", "2", "3","4","5"
Company E	"3","4","5"
Company F	"4","5"

I would like to have a filter for example, on the filter, it should show only single value, e.g: 1,2,3,4,5 

And when I choose 1, it should show the data like this:

Name

Company A

Company B

Company C

Company D

When I choose 4, it should show:

Name

Company A

Company C

Company D

Company E

Company F

Thank you for your help and support 🙂

[Iceberg12]

This works perfectly, thanks much 🙂

[amitchandak · Accepted solution]

@Iceberg12 , refer this solution

Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
https://medium.com/@amitchandak/power-bi-search-text-parts-in-text-ad2f9783ffa2

Or create an independent table with values 1 to 5

Tab = Generateseries(1,5,1) // do not join

Then use that in filter and use a measure like this with company 

Countrows(filter(Table, containsstring([code], selectedvalues(Tab[Value]) )))

Power BI: DAX Functions: Search, Find,containsstring, containsstringexact: https://youtu.be/cN8AO3_vmlY?t=21228