cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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 🙂

1 ACCEPTED SOLUTION
Super User

@Iceberg12 , refer this solution

Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c

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

2 REPLIES 2
Frequent Visitor

This works perfectly, thanks much 🙂

Super User

@Iceberg12 , refer this solution

Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors