Business Intelligence with Power BI

L11 · The Power BI Service

Practice — Mild · Solution

Verified checkpoints

CheckValue
Midwest Manager, Total Revenue$8,706,946.00 (2023–2026 Midwest sum)
Online Manager, Total Revenue$29,892,682.72
Every page under each roleAll facts narrow together — the star routes the role's filter everywhere
Mobile layoutVertical stack, attainment card leading

Reflection answers

  • Under Online Manager the state map renders empty — Online has no states, so the role's filter leaves the map nothing to draw. Correct, and doubly instructive: it is the L08 missing-geography lesson enforced by security, and it argues the Online manager's version of the page should probably swap the map for the customer-state analysis the L08 Hot practice invented.
  • RLS verification figures should come from the model's own verified visuals/manifest, never from expectation — the same source discipline as every number in this course. A role verified against a guessed figure is half-verified.