Anyway to filter fields in a table by selecting the item?

[SimpoPower]

Hello, is there anyway to filter rows in a table by selecting a data field in the table.

For example, a screenshot of the table below:

I would like to select the data 'A closed project' in the table, then the table would filter and only show rows with 'A closed project'.  Currently when I select this it just greys out all the other rows in the table so no filtering by this field.  Anyway to do this?

[dax · Accepted solution]

Hi @SimpoPower ,

As I know, there is not available currently(you want to click on row and only show this row in visual). It only could highlight the row or affect other rows in other visual like above video. 

So I suggest you could use slicer to filter corresponding data and you could submit this requirement on power-bi-ideas .

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

Generally you use slicers for that sort of thing

[Mariusz]

Hi @SimpoPower 

You can create another visual or slicer with Project status and use it to cross filter your table visual.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn