Bicycle.LLCSchedule a call

← Dashboard collection

Choose dashboard — Executive

people analytics dashboard

Executive

A five-page executive report spanning the overview, KPI summary, organizational comparison, scorecard, and definitions.

5 pages · Power BI

These dashboards use synthetic workforce data. Values illustrate the report design.

Choose page — 1 KPI Summary

Selected page

1 KPI Summary

DAX definitions

Exact source expressions and direct measure dependencies for the selected page.

KPI Benchmark Numeric

CompanyScorecard · KPI Summary

IF(ISEMPTY(AsOf), BLANK(), IF(COUNTROWS(CompanyScorecard) = 1 && NOT ISBLANK(SELECTEDVALUE(CompanyScorecard[benchmarkValue])), VAR v = SELECTEDVALUE(CompanyScorecard[benchmarkValue]) RETURN IF(SELECTEDVALUE(CompanyScorecard[unit]) = "percent", v * 100, v), BLANK()))

Direct dependencies: None

KPI Change Numeric

CompanyScorecard · KPI Summary

IF(ISEMPTY(AsOf), BLANK(), IF(ISBLANK([KPI Current Numeric]) || ISBLANK([KPI Prior Numeric]), BLANK(), VAR v = SELECTEDVALUE(CompanyScorecard[changeValue]) RETURN IF(SELECTEDVALUE(CompanyScorecard[unit]) = "percent", v * 100, v)))

Direct dependencies: KPI Current Numeric, KPI Prior Numeric

KPI Current Numeric

CompanyScorecard · KPI Summary

IF(ISEMPTY(AsOf), BLANK(), IF(COUNTROWS(CompanyScorecard) = 1 && SELECTEDVALUE(CompanyScorecard[n]) >= 10 && SELECTEDVALUE(CompanyScorecard[suppressed]) = 0, VAR v = SELECTEDVALUE(CompanyScorecard[currentValue]) RETURN IF(SELECTEDVALUE(CompanyScorecard[unit]) = "percent", v * 100, v), BLANK()))

Direct dependencies: None

KPI Expected High Numeric

CompanyScorecard · KPI Summary

IF(ISEMPTY(AsOf), BLANK(), IF(COUNTROWS(CompanyScorecard) = 1 && NOT ISBLANK(SELECTEDVALUE(CompanyScorecard[expectedHigh])), VAR v = SELECTEDVALUE(CompanyScorecard[expectedHigh]) RETURN IF(SELECTEDVALUE(CompanyScorecard[unit]) = "percent", v * 100, v), BLANK()))

Direct dependencies: None

KPI Expected Low Numeric

CompanyScorecard · KPI Summary

IF(ISEMPTY(AsOf), BLANK(), IF(COUNTROWS(CompanyScorecard) = 1 && NOT ISBLANK(SELECTEDVALUE(CompanyScorecard[expectedLow])), VAR v = SELECTEDVALUE(CompanyScorecard[expectedLow]) RETURN IF(SELECTEDVALUE(CompanyScorecard[unit]) = "percent", v * 100, v), BLANK()))

Direct dependencies: None

KPI Prior Numeric

CompanyScorecard · KPI Summary

IF(ISEMPTY(AsOf), BLANK(), IF(COUNTROWS(CompanyScorecard) = 1 && SELECTEDVALUE(CompanyScorecard[qualifiedPriorN]) >= 10 && SELECTEDVALUE(CompanyScorecard[priorSuppressed]) = 0, VAR v = SELECTEDVALUE(CompanyScorecard[qualifiedPriorValue]) RETURN IF(SELECTEDVALUE(CompanyScorecard[unit]) = "percent", v * 100, v), BLANK()))

Direct dependencies: None

KPI Range Display

CompanyScorecard · KPI Summary

IF(ISEMPTY(AsOf), BLANK(), IF(COUNTROWS(CompanyScorecard) = 1, SELECTEDVALUE(CompanyScorecard[rangeIcon]) & " " & SELECTEDVALUE(CompanyScorecard[rangeStatus]), BLANK()))

Direct dependencies: None

KPI Trend Display

CompanyScorecard · KPI Summary

IF(ISEMPTY(AsOf), BLANK(), IF(ISBLANK([KPI Change Numeric]), BLANK(), SELECTEDVALUE(CompanyScorecard[trendIcon]) & " " & SELECTEDVALUE(CompanyScorecard[trendState])))

Direct dependencies: KPI Change Numeric