Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
OneWithQuestion
Post Prodigy
Post Prodigy

Filter table by clicking on column?

Is there any visual or option to enable filtering by the column heading on a data table?

 

It seems like it would be EXTREMELY useful to be able to just click on a header and filter like how you can in Excel on a table.

 

 (Same as how you can in SPO lists as well for example)

3 REPLIES 3
Anonymous
Not applicable

I'm not aware of a custom visual that allows for this outside of something overkill like SandDance, but you could put slicers set to drop-down on top of the columns, just make sure you've manually resized the columns so they stay aligned. It ain't perfect, but it's a start.

 

I think it's worth noting that this is intentional to some degree, given the fact that Power BI looks at the context of the whole page, rather than just one single table. Typically, if your table is being filtered, you want everything else to filter as well, so it makes more sense in most situations to have a slicer anyway.

True it would need to be a feature where it filters the whole page in the same way clicking a row inside the table filters the paage (depending how the table filters are set to interact)
Anonymous
Not applicable

Have they added it now or is it still not available ?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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