Filters in Table Visuals Column Header

[Priyamxylem]

Can we make column header of a table visual to act like a slicer like how we get in excel file where we have filter options available in each column to filter the table data

e.g.

We can filter the Location in excel file :

@power2 @PowerBI @powerbi3 @npowerbi @powerbi2 

[v-nmadadi-msft]

Hi @Priyamxylem,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-nmadadi-msft · Accepted solution]

Hi  @Priyamxylem ,
Thanks for reaching out to the Microsoft fabric community forum.

In Table view you get the option to filter the values when you click the drop down button

based on our input table will get filtered

If you want the same feature in report view we have to utilize slicers or field parameters, Slicers in Power BI allow users to filter data directly on the report canvas, making it easy to highlight performance by district managers or specific time frames. They offer quick access to commonly used filters, improve visibility of the filtered state, and help create more focused reports by filtering hidden or unnecessary columns.

Slicers in Power BI - Power BI | Microsoft Learn

Use parameters to visualize variables - Power BI | Microsoft Learn

Use report readers to change visuals (preview) - Power BI | Microsoft Learn

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards

[Idrissshatila]

Hello @Priyamxylem ,

Power BI doesn't work as in sql, so as @Deku mentioned you can add slicers that would look like the excel and you can have it above the table visual.

[Deku]

This is not possible, you can add slicers to the page or add filters using the filter pane