Data Profiling allows you to easily find issues with your data within the Power Query Editor. In addition to the inline Column Quality bar and Value Distribution histograms, you can use the Column Profiles pane. This pane provides deeper profiling capabilities for any given column, including:
Column statistics # of errors, empty, valid, duplicated and unique values. Value distribution measures such as Min/Max/Average/Median, etc.
Column distribution Larger version of the inline value distribution histograms, also including the ability to Keep or Remove values, which will generate the corresponding Filter Rows step in your query (“Equals” / “Does Not Equal” filters).
Display Data Profiling elements
Open the View tab in the Power Query Editor.
In the Data Preview group, select the elements you want to display: