A Power BI developer needs to implement a ‘what-if’ analysis where the user adjusts a discount percentage via a slider and sees updated profit figures instantly. Which Power BI feature supports this? Power BIHard Try Now
What happens to a Power BI report that is embedded using the ‘Publish to Web’ feature? Power BIHard Try Now
A DAX developer writes: VAR Result = CALCULATE([Sales], FILTER(ALL(Products), Products[Category] = ‘Electronics’)) RETURN Result. What is the advantage of using VAR in this context? Power BIHard Try Now
Which Power BI gateway mode supports multi-user access and is recommended for enterprise production environments? Power BIHard Try Now
When using SUMMARIZE() in DAX to create a grouped summary table, what additional function should be used instead of adding extension columns directly in SUMMARIZE() to avoid incorrect results? Power BIHard Try Now
Which Power BI feature allows administrators to classify and protect Power BI content using Microsoft Purview sensitivity labels? Power BIHard Try Now
A Power BI report developer needs to implement a custom tooltip page that shows detailed KPIs when hovering over a bar chart. What must the developer do to enable this? Power BIHard Try Now
A Power BI model contains a Sales fact table with 500 million rows in Azure Synapse. The team wants fast interactive reports without importing data. Which connectivity approach provides the best query performance while keeping data in Synapse? Power BIHard Try Now
Which DAX function is used to iterate over a table and return a single scalar value by applying an expression to each row? Power BIHard Try Now
A developer needs to dynamically change the measure displayed in a visual based on a slicer selection (e.g., toggling between Revenue, Profit, and Units). Which Power BI technique achieves this? Power BIHard Try Now
In Power BI Paginated Reports, what is the primary use case compared to standard Power BI reports? Power BIHard Try Now
A Power BI developer needs to create a measure that returns the percentage contribution of the selected category to the grand total, remaining correct regardless of which slicers are applied. Which DAX pattern is correct? Power BIHard Try Now
