Watch videos with subtitles in your language, upload your videos, create your own subtitles! Click here to learn more on "how to Dotsub"

3-6

0 (0 Likes / 0 Dislikes)
  • Embed Video

  • Embed normal player Copy to Clipboard
  • Embed a smaller player Copy to Clipboard
  • Advanced Embedding Options
  • Embed Video With Transcription

  • Embed with transcription beside video Copy to Clipboard
  • Embed with transcription below video Copy to Clipboard
  • Embed transcript

  • Embed transcript in:
    Copy to Clipboard
  • Invite a user to Dotsub
>> As well as charts, Power BI has some tabular visualizations you can use to look at your data. So for example, this little icon lets me insert a table, and I can start adding fields to this to start building up a textural set of data. You'll actually get that by default if you use a text field from your model as a visual. So I'll just tick Category, you'll see that a table will get created for you by default. As I add more fields, you'll see more columns get added into that table. And we can do things like resizing, moving the table just like anything else, but I can also grab the columns themselves to resize them. A little black area that you get when you hover over things indicates that when you click it, it will sort the table based on the values in the column that you click. You can also double-click on the column separators to auto-size the columns based on the data that's available. And you'll see if you've got particularly large data set, as you scroll through and more data gets loaded, those columns might need to resize, particularly if your data is... You're going to pull back some more data that's got very long strings in it, it might need to be resized. If I start to add numerical fields to this such as Unit Sales or Year to Date Revenue, you'll see the Totals row gets turned on at the bottom of this table, and we can see the overall Total Unit Sales and Year to Date Revenue for all of our Category, Segment, Manufacturers, etcetera. Headers and the total rows are pinned to the top and bottom of your Visual by default. But as I scroll through it, I can always see those Totals and the Headers. The other way that you can lay out your data is a Matrix Visualizations. So that's this little icon here. And you'll see in the field, well, I get a few different options here. We get Rows, Columns, and Values. Let's put our Units back in Values and let's look our different Category Sales. And this time, I'm going to put our Year on the Columns. And here, I get this kind of cross-tab view. More like a pivot table in Excel where I can see my different category sales down the rows and for each column, I've got a different year. I can scroll left and right through this as well and you'll see I get a column with the Total Unit Sales over on the right-hand side. The other difference with a matrix is that when I add multiple levels into a row, you'll see how you don't get repeated values in each one of these. It's more sort of stepped in, again, kind of like a pivot table in Excel. Let's take a look at how you can format these Visualizations in different ways. I'm going to go back to a table just to build something simple, let's look at our Category, Segment, and Sales, for each one of those as well. Over on the Formatting pane, there's a whole range of options that you have these tables. You can do things like setting that Auto size, so whether when you load more data, do the columns automatically get bigger and smaller based on the type of data in there? You've got a slider to just set the text size. If you want to get bigger or small text, you can change that. And you can turn the Total row on and off. You've also got a whole range of options to change the formatting, things like the colors, the size the layout of elements like the Grid lines, the actual Values in your data, etcetera, etcetera. So let's do things like changing the column headers, I could make that a yellow color. And then maybe on my Values, I want to set like alternating background color rows. So let's change between white and this yellow color or maybe a nicer gray color to just make it easier to distinguish when you're reading across these different rows in the table, which values correspond to which categories. If I wanted to add some more grid lines into this, I can do that here as well. So for example, under Grid, I'll get options, my vertical and horizontal grid. Then on the vertical grid lines, you can see I've got some options to make them bigger or smaller, change the colors of those. I could produce a fairly garish looking table if I wanted to combine all of the different colors together... And recommending that you keep it simple, try to minimize the number of different options that you use here. But you've got a lot of control over making these things look exactly how you want. Okay, the last thing that we can do is actually set the background of cells in a table or matrix based on the value of the data. So this is kind of conditional formatting where I can say, you know, I want to have red for low values and green for high values. Let's take a look at how that works. So you can see my Field Well, I've got Revenue field. And when I click on the drop-down for that, I get this Conditional Formatting option. This will pop-up a dialog where I can choose which values and what colors I want to map to those values. So by default, you'll get a light to dark sort of scale. And if I hit OK, you'll see now the formatting has been applied, so the background color of the cells in this table is changing based on the values, the highest values in the darkest green. I can also change this to use a diverging scale. For example, if I had some variance to target, I had negative and positive numbers, maybe I would want to use red to green then. If you're colorblind, maybe you want to use some different scales, that's a common challenge. So you get the idea, I can apply a bunch of different formatting to format the background of these cells based on the values within it.

Video Details

Duration: 5 minutes and 40 seconds
Country: United States
Language: English
License: All rights reserved
Genre: None
Views: 25
Posted by: csintl on May 25, 2016

----- (Please provide translations for these languages: Chinese (Simplified) (chi_hans), Chinese (Traditional) (chi_hant), English (eng), French (France) (fre_fr), German (ger), Italian (ita), Japanese (jpn), Korean (kor), Portuguese (Brazil) (por_br), Russian (rus).)

Caption and Translate

    Sign In/Register for Dotsub to translate this video.