Exercises

  • Drop-down Sheet Selector & Dynamic Zones

    Create a dashboard that navigates between three different views and corresponding filter controls.

    Go to Exercise

  • Filter the View, not the Underlying Data

    Filter the view but still use all the data in calculations

    go to exercise

  • Level of Detail Expressions

    Explore how totals change with different level of detail expressions.

    Go to exercise

  • Sheet Selection Menu

    Use a parameter as a “menu” to switch between two worksheets.

    Go to Exercise