Forum Discussion
Filter rows data
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 , 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-ad2f9783ffa2Or 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
2 Replies
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-ad2f9783ffa2Or 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
This works perfectly, thanks much 🙂
