Join Gini von Courter for an in-depth discussion in this video Creating and using a table visualization, part of Power BI Features in Depth.
- View Offline
- Exercise Files
It's very easy to create a new Power View table visualization. I have here a table of data about populations. This is countries, the regions of the world they're in, the population, and the year that population was reported. And the earliest year in here would be, I believe, 1901. It's 20th-century data. This is a set that I created from data mostly from gapminder.org. But also some data on regions from about.com. I want to create a power view.
Insert in the report section power view report. Depending on how many columns of data you have. This can take some time. So this is a very simple table and we'll see it pretty quickly. Notice that the name that comes in is not the name of the sheet but it's actually the name of the table. Its population con region and its created a table in my report immediately, just like that. It's right here. What it did was it dropped all the data in so it looks pretty much like the worksheet. Although in the worksheet I had years formatted as years and here there formatted as short dates. So here's what we're going to do. I actually don't want to look at countries. I simply want to be able to look at regions. So let's take out everything but region, there's the name of region. I want to know how many countries there are in each of these regions. So now I'm going to add country, but what I'd like to do with country is I want to count the distinct countries. So in my fields area everything's a field here, the same word as column, right. Power view columns, power view fields. I want to count the distinct items in each region. Just like that. So there's each of my regions, the count of the countries in each region. I can sort this by count, I can sort this by region just as if I was in Excel. I have a filter. So I can show filters and it will create a filter for the two columns that I have, so I can say I don't want to see all the regions. I want to see Asia, Europe, and Australia, and Oceania, that it.
And immediately I can clear that. So I have a filter area that is not hard for me to use at all. I can click here and add a title to my report. I can hide the filters areas if I want or show it. I can hide the field list, or show it. This looks pretty good so far. Now, I also have access to lots of formatting tools that we're going to look at in a moment. But this how easy it was to create a basic table report out of the information I had. About the same amount of effort that we would have put into, for example. Creating a power pivot chart or an Excel pivot chart to display this same data.
Pretty easy. I'm going to hang onto this workbook because we're going to use it again in the next few movies as we add some other visualizations and do some formatting.
AuthorGini von Courter
- Understanding data analysis and business intelligence
- Installing Office BI add-ins
- Searching for online data with Power Query
- Shaping data in the Query Editor
- Connecting to data sources
- Modeling data with Power Pivot
- Enhancing PivotTables and PivotCharts with PowerPoint
- Visualizing geospatial data with Power Map
- Creating and formatting Power View reports
- Sharing your data using Power BI for Office 365
Skill Level Intermediate
1. Getting Started: Self-Service, Power BI, and BI Tools
2. Using Power Query to Get Data
3. Modeling Your Data with Power Pivot
4. Enhancing PivotTables and PivotCharts with Power Pivot
5. Expanding the Data Model in Power Pivot
6. Visualizing Geospatial Data with Power Map
7. Creating and Formatting Power View Reports
8. Creating Other Power View Visualizations
9. Sharing Your Data Using Power BI for Office 365
Next steps2m 59s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.