Forum Discussion
Filters in Table Visuals Column Header
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 :
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
4 Replies
This is not possible, you can add slicers to the page or add filters using the filter pane
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.
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 RegardsHi 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.
