Book Image

Microsoft Power BI Cookbook

By : Author Test, Brett Powell
Book Image

Microsoft Power BI Cookbook

By: Author Test, Brett Powell

Overview of this book

Microsoft Power BI is a business intelligence and analytics platform consisting of applications and services designed to provide coherent, visual and interactive insights of data. This book will provide thorough, technical examples of using all primary Power BI tools and features as well as demonstrate high impact end-to-end solutions that leverage and integrate these technologies and services. Get familiar with Power BI development tools and services, go deep into the data connectivity and transformation, modeling, visualization and analytical capabilities of Power BI, and see Power BI’s functional programming languages of DAX and M come alive to deliver powerful solutions to address common, challenging scenarios in business intelligence. This book will excite and empower you to get more out of Power BI via detailed recipes, advanced design and development tips, and guidance on enhancing existing Power BI projects.
Table of Contents (14 chapters)

Configuring custom KPI and slicer visuals

Per previous chapters, the KPI visualization type is commonly used to provide at-a-glance insights in Power BI dashboards and from the Power BI mobile application via mobile-optimized reports and dashboards. Additionally, the slicer visualization type delivers a robust self-service filtering capability to consumers of Power BI content across all data types. Given the importance of these two use cases Microsoft has developed the dual KPI and chiclet slicer custom visualizations to provide even more analytical features and design options such as the percentage change of a KPI value relative to a specific date and the use of images as slicer items.

In this recipe, the steps required to create the headcount and labor expenses dual KPI from enterprise dashboard example in Chapter 5, Creating Power BI Dashboards, are fully described. Additionally...