Data Table Filters
How do I filter the data table in Power BI Desktop’s Data view?
TL;DR. The June 2018 Power BI Desktop release added filtering to the Data view. Drop-down icons appear on the data table so you can filter the raw rows loaded into your model, much like an Excel table. The post’s video shows it.
When did Power BI Desktop add data table filtering?
Data table filtering arrived in the June 2018 Power BI Desktop release. I called it the best feature of the year to date, and the post links Microsoft’s June 2018 feature summary for the official details.
Where do the filter controls appear?
In Power BI Desktop, go to the view the June 2018 post calls Data Table. While you are on that view, drop-down icons appear that let you filter the data table. That name and layout come from the 2018 post.
What is data table filtering useful for?
It helps when you want to look at the raw data that has been loaded into your data model. Filtering lets you narrow the rows you are inspecting without building a visual.
Will this feel familiar if I use Excel?
Yes, if you like data tables in Excel. The post says you will feel right at home, with a pivot table type feel.
Is there a video walkthrough?
Yes, the post embeds the PowerBI.Tips tutorial video “Data Table Filtering - My Favorite Feature of 2018” on YouTube. It shows how the feature works.
Related: Apply a Filter to a Slicer, Segmented Filtering with Slicers, and Adding Data Types Within Query Editor.
Hands down best feature this year to date, Data Table Filtering! In the June 2018 Power BI Desktop Microsoft released the ability for you to navigate to the Data Table view. While on this view drop down icons now appear which enable filtering of the Data Table. This is super helpful when looking at the raw data that has been loaded into your data model. Check out the video below to see how the feature works.
Other Thoughts:
For those of you who like Excel, and data tables in Excel, this feature will make you feel right at home within a pivot table type feel. I hope you enjoy this month’s update as much as I did. Thanks for stopping by.
For the official documentation from Microsoft follow this link to the blog announcement.