From the course: Power BI for Finance
Join today to access over 25,200 courses taught by industry experts.
Creating tables - Power BI Tutorial
From the course: Power BI for Finance
Creating tables
- [Instructor] Within data models. dimensions are the fields like dates and categories that form the backbone of our visuals, like tables. Aggregates and measures are the numbers whose results depend on the dimensions that we add to our tables and other visuals. For creating tables as visuals. Power BI offers two options. The table visual, which lets us slot the field into columns, and the feature-rich matrix visual, which lets us add hierarchies to the rows and expands across columns for the values that we add to it. With both of these table options, we can also format them using Power BI's built in formatting options. Let's start by adding a table visual to our report page. We'll put the date from the Dates table in the first column and the amount field from the Actuals table into the second column. In general, we want to put the dimensions in the first columns toward the left and the aggregated numbers are measures in the columns toward the right. If the text is hard to read, we…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.