In the data view for a Power Query dataflow, which option shows the distribution of column values?

In the data view for a Power Query dataflow, which option shows the distribution of column values?

• A. Show column value distribution
• B. Enable details pane
• C. Enable column profile
• D. Show column quality details

Answer: (A)

Understanding how values in a column are spread is essential for quick data profiling. In the data view, the option that shows column value distribution provides a visual summary of how often each value occurs in that column, usually like a small histogram. This makes it easy to see patterns such as concentration on a few values, many distinct values, or a lot of missing/nulls. That direct visualization of how values are distributed is why this option is the best choice. Other options show different aspects—details pane for metadata, column profile for general statistics (min, max, distinct count, etc.), and quality details for data validity measurements—but they don’t depict the distribution of values in the column as clearly.

Understanding how values in a column are spread is essential for quick data profiling. In the data view, the option that shows column value distribution provides a visual summary of how often each value occurs in that column, usually like a small histogram. This makes it easy to see patterns such as concentration on a few values, many distinct values, or a lot of missing/nulls. That direct visualization of how values are distributed is why this option is the best choice. Other options show different aspects—details pane for metadata, column profile for general statistics (min, max, distinct count, etc.), and quality details for data validity measurements—but they don’t depict the distribution of values in the column as clearly.