Q61
Q61 Which DAX function is used to sum a column?
SUM
SUMX
ADD
TOTALSUM
Q62
Q62 Which function would you use to perform a conditional sum in DAX?
SUM
CALCULATE
COUNT
AVERAGE
Q63
Q63 What is the purpose of the SUMX function in DAX?
Performs a row-by-row calculation before aggregation
Calculates the average of a column
Returns the maximum value
Creates a running total
Q64
Q64 Which DAX function is used to dynamically change relationships between tables?
TREATAS
LOOKUPVALUE
SWITCH
RELATED
Q65
Q65 A measure is not returning expected results due to incorrect filter context. What should you check?
The relationship direction
The data type
The query limit
The table name
Q66
Q66 A DAX formula is returning blank values. What could be the cause?
Incorrect column references
Circular dependencies
Filter context issues
All of the above
Q67
Q67 A DAX calculation using SUMX is taking too long to execute. What could be the issue?
Too many visuals on the page
Large dataset size
Inefficient row-based calculations
Improper relationship filters
Q68
Q68 What is the primary purpose of visualizations in Power BI?
To store data
To improve query performance
To represent data graphically
To modify data sources
Q69
Q69 Which visualization is best for comparing numerical values across categories?
Pie Chart
Line Chart
Bar Chart
Scatter Plot
Q70
Q70 What is a slicer used for in Power BI?
To modify report themes
To filter data in reports
To create calculated columns
To change data types
Q71
Q71 Which visualization is best suited for showing trends over time?
Column Chart
Pie Chart
Line Chart
Matrix
Q72
Q72 What type of visualization allows you to drill down into hierarchical data?
Treemap
Gauge Chart
Funnel Chart
Stacked Column Chart
Q73
Q73 How do you create a calculated field for use in a visualization?
Use a DAX measure
Modify Power Query
Change column data types
Edit visualization properties
Q74
Q74 Which DAX function can be used to dynamically change the color of a visual?
IF
SWITCH
FORMAT
LOOKUPVALUE
Q75
Q75 Which property allows Power BI visuals to automatically adjust based on screen size?
Auto-scale
Responsive
Dynamic
Stretch
Q76
Q76 Which visual formatting option in Power BI allows conditional background color formatting?
Visual Styles
Field Formatting
Conditional Formatting
Theme Editor
Q77
Q77 A visualization is not displaying data correctly. What could be the cause?
Incorrect relationships
Too many filters
Data not refreshed
All of the above
Q78
Q78 A report takes too long to load due to visualizations. What is a possible solution?
Reduce the number of visuals
Increase dataset size
Use more colors
Disable filters
Q79
Q79 A tooltip is not appearing in a visualization. What could be the issue?
Tooltip is disabled
Data model error
Missing fields in report
Filters not applied
Q80
Q80 What is the primary difference between a dashboard and a report in Power BI?
Dashboards display multiple reports
Reports display multiple dashboards
Dashboards support drill-through while reports do not
Reports are real-time, dashboards are not
Q81
Q81 How can you pin a visual from a report to a dashboard?
Click "Pin to Dashboard"
Drag and drop the visual
Use Power Query
Apply a DAX function
Q82
Q82 What type of reports can be created in Power BI?
Static Reports only
Paginated Reports only
Interactive and Paginated Reports
Real-time only
Q83
Q83 What feature allows users to apply filters to an entire Power BI report?
Page-Level Filters
Visual-Level Filters
Report-Level Filters
Dashboard Filters
Q84
Q84 What is the purpose of data-driven alerts in Power BI dashboards?
To notify users when a specific data condition is met
To refresh the dataset automatically
To modify visuals dynamically
To export reports to Excel
Q85
Q85 How do you create a calculated measure for a report?
Use a DAX formula
Modify Power Query
Change visual properties
Create a new data table
Q86
Q86 What is the purpose of the "Drillthrough" feature in Power BI?
To navigate between report pages with detailed insights
To change the report theme
To merge datasets
To refresh data sources
Q87
Q87 Which DAX function can be used to create a rolling average for trend analysis?
AVERAGE
CALCULATE
MOVINGAVERAGE
AVERAGEX
Q88
Q88 Which DAX function can be used to calculate a running total in a report?
SUMX
TOTALYTD
RUNNINGSUM
CUMULATIVE
Q89
Q89 A report is not updating after data refresh. What should be checked first?
Page-Level Filters
Dataset Refresh Settings
Dashboard Theme
Report Permissions
Q90
Q90 A dashboard visual is showing incorrect values. What could be the cause?
Incorrect data model
Visual filters applied
Data refresh not completed
All of the above
