Summary

In this chapter, we learned about the importance of proper planning when creating a final report. Planning a report by thinking about how users will use and interact with the report will make the report creation process go more smoothly and help ensure that users find the report intuitive and easy to use. Thinking ahead about using sync slicers and report filters can save time and effort. Using a theme ensures that colors are consistent throughout the report and can also save time by reducing the amount of formatting that's required for visuals. Creating a page template can also save time and effort when creating multiple report pages.

While creating the various pages of the utilization report, we learned valuable lessons about how to overcome the limitations of certain visuals by using DAX, as well as how to use DAX to create dynamic titles that are helpful when working with the drill-through feature and how to add visual cues by using SVG and data categorization....