Summary

In this chapter, we built upon the data model and calculations we created in the previous chapter and learned how to take advantage of the powerful features within Power BI. These features include the ability to segment our data into groups and hierarchies. In addition, we learned how to expand, collapse, and drill up and down through hierarchies, as well as how to use RLS. Next, we learned how additional Power BI features such as drill-through, buttons, Q&A, and bookmarks can be used to provide navigational pathways within reports that viewers can use to unlock self-service business intelligence insights.

Finally, we explored advanced analysis techniques such as Analyze, Summarize, Top-N filtering, gauge visualizations, KPI visualizations, what-if parameters, conditional formatting, quick measures, report tooltip pages, and the advanced key influencers visualization. These advanced analysis and visualization techniques allow the report author to build truly engaging...