Book Image

Microsoft Power BI Complete Reference

By : Devin Knight, Brian Knight, Mitchell Pearson, Manuel Quintana, Brett Powell
Book Image

Microsoft Power BI Complete Reference

By: Devin Knight, Brian Knight, Mitchell Pearson, Manuel Quintana, Brett Powell

Overview of this book

Microsoft Power BI Complete Reference Guide gets you started with business intelligence by showing you how to install the Power BI toolset, design effective data models, and build basic dashboards and visualizations that make your data come to life. In this Learning Path, you will learn to create powerful interactive reports by visualizing your data and learn visualization styles, tips and tricks to bring your data to life. You will be able to administer your organization's Power BI environment to create and share dashboards. You will also be able to streamline deployment by implementing security and regular data refreshes. Next, you will delve deeper into the nuances of Power BI and handling projects. You will get acquainted with planning a Power BI project, development, and distribution of content, and deployment. You will learn to connect and extract data from various sources to create robust datasets, reports, and dashboards. Additionally, you will learn how to format reports and apply custom visuals, animation and analytics to further refine your data. By the end of this Learning Path, you will learn to implement the various Power BI tools such as on-premises gateway together along with staging and securely distributing content via apps. This Learning Path includes content from the following Packt products: • Microsoft Power BI Quick Start Guide by Devin Knight et al. • Mastering Microsoft Power BI by Brett Powell
Table of Contents (25 chapters)
Title Page
About Packt
Contributors
Preface
Index

Visualizing tabular data


We will see that there are many options within Power BI to visually represent data, but sometimes our users may want to see and compare detailed data and exact values. In these scenarios, using the Table or Matrix visual ends up being our best choice. When leveraging either of these two visuals, it is important to take advantage of the Format area to ensure that users can easily interpret the detailed data that is being presented. One of the best ways to bring attention to values of importance with these visuals is by using Conditional Formatting. We will explore this option, as well as take advantage of the hierarchies we created in Chapter 3, Building the Data Model, to allow for drill downs within the visuals.

The table visual

The table visual is perfect for looking at many values (measures) for a category. To really make the table shine, we will also want to take advantage of the Conditional Formatting option that is available to us. In our example, we will be...