Forum Discussion
How to filter a table in Power Bi
I'm trying to filter the table in Power Bi, but what I want to achive is when I'm clicking I want to have the rows with the same name.
For example:
| Department | Category | Action |
| Marketing | 1 | a |
| Marketing | 2 | d |
| Accountin | 3 | a |
If I click on Marketing cell, I want the table to filters to show only Marketing rows.
On the other hand if I click on "a" in Action I also want it to be filtering.
How to achieve that?
Hello PatMic090 ,
you add slicers for the department and action and you can filter the table visual with the mentioned data.
check how to add slicers in power bi https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers?tabs=powerbi-desktop
1 Reply
- Idrissshatila
Super User
Hello PatMic090 ,
you add slicers for the department and action and you can filter the table visual with the mentioned data.
check how to add slicers in power bi https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers?tabs=powerbi-desktop