Microsoft Power BI Complete Reference

coverpage

Title Page

Copyright

Microsoft Power BI Complete Reference

About Packt

Why subscribe?

PacktPub.com

Contributors

About the authors

About the reviewers

Packt is searching for authors like you

Preface

Who this book is for

What this book covers

To get the most out of this book

Download the example code files

Conventions used

Get in touch

Reviews

Getting Started with Importing Data Options

Getting started

Importing data

Excel as a source

SQL Server as a source

Web as a source

DirectQuery

Limitations

Live Connection

Limitations

Which should I choose?

Summary

Data Transformation Strategies

The Power Query Editor

Transform basics

Use First Row as Headers

Remove Columns

Change type

Add Column From Examples

Advanced data transformation options

Conditional Columns

Fill Down

Unpivot

Merging Queries

Appending Queries

Leveraging R

Installation and configuration

The R Script transform

M formula language

#shared

Summary

Building the Data Model

Building relationships

Editing relationships

Creating a new relationship

Working with complex relationships

Many-to-many relationships

Cross-filtering direction

Enabling filtering from the many side of a relationship

Role-playing tables

Importing the date table

Usability enhancements

Hiding tables and columns

Renaming tables and columns

Default summarization

How to display one column but sort by another

Data categorization

Creating hierarchies

Summary

Leveraging DAX

Building calculated columns

String functions – Month Year

Format function – Month Year

Age calculation

SWITCH() – age breakdown

Navigation functions – RELATED

Calculated measures – the basics

Calculated measure – basic aggregations

Total Sales

Total Cost

Profit

Profit Margin

Optional parameters

Filter context

Calculate

Percentage of total calculation

Time intelligence

Year to Date Sales

YTD Sales (Fiscal Calendar)

Prior Year Sales

Summary

Visualizing Data

Data visualization basics

Visuals for filtering

Interactive filtering

The Slicer visual

Visualizing tabular data

The table visual

The Matrix visual

Visualizing categorical data

Bar and Column charts