Question 160
In a Microsoft Power BI project, A product report must show revenue by product and enable users to expand from category to individual SKU. Choose the most defensible solution.
Explanation
Correct Answer
This directly addresses the stated constraint. A matrix supports grouped rows, columns, subtotals and drill interactions. Confirmation: Users can expand a category to view SKU lines and subtotal correctly.
Incorrect Answers
Putting cost on an unlabelled secondary axis can imply false correlation. The specific problem here is that a Card visual cannot show the requested drill-down hierarchy.
Treating an automated explanation as proven causation ignores correlation limits. The specific problem here is that a Card visual cannot show the requested drill-down hierarchy.
Using a static chart title as a toggle does not change the underlying plotted measure. The specific problem here is that a Card visual cannot show the requested drill-down hierarchy.