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)

Adding a metric placeholder dimension

As date intelligence and other measures are added to a data model, it becomes necessary to organize measures into dedicated measure group tables in the Fields list. These tables, displayed with calculator symbols at the top of the Fields list, make it easier for users and report developers to find measures for building and modifying Power BI reports. The Setting the visibility of columns and tables section of Chapter 3, Building a Power BI Data Model briefly introduced the concept of measure group tables in the How it works... section, but didn't specify the process to implement these objects.

This recipe provides step-by-step guidance for a method of implementing measure group tables that works with both DirectQuery and Import data models.

...