In Power BI Desktop, you are inspecting a large fact table in Power Query Editor. After turning on Data Profiling, you need to view the minimum, maximum, average (mean), and standard deviation for the Amount column so you can spot outliers before loading the data. Which View-tab option should you enable, and then click the column, to display all of those statistics in a single pane?
The Column profile feature opens a pane at the bottom of Power Query Editor that combines detailed column statistics (including minimum, maximum, mean, standard deviation, count, null count, and more) with a value-distribution chart. Selecting a column immediately shows these metrics, making it ideal for identifying outliers. Column distribution only shows a small histogram plus distinct and unique counts, Column quality only shows percentages of Valid/Error/Empty values, and Query diagnostics is unrelated to profiling columns. Therefore, Column profile is the correct choice.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What does Data Profiling in Power BI do?
Open an interactive chat with Bash
How does the Column profile differ from Column distribution?
Open an interactive chat with Bash
Can Query diagnostics be used for analyzing columns?
Open an interactive chat with Bash
Microsoft Power BI Data Analyst
Prepare the data
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .