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


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
To help your users navigate through your data, you can create hierarchies to help them understand the different levels in your data and how they can move up and down between them. Let's take a look at how you can build those and work with them in Power BI. So I've got some data here. And you can see that I've got Category, Segment, Manufacturer, and Products. So within each category, we'll have multiple segments. Within each segment, there are multiple manufacturers who produce individual products. And to help users navigate through this data, we can create a hierarchy. Over in the field list, you can see I've got in my Product table Category, Manufacturer, Product, and Segment. And to start building a hierarchy, I can just drag one of these fields onto the other. Let's take our Segment, drag it onto Products. And then I can take Manufacturer, drag that onto the hierarchy in that category as well. And now you'll see I've got all of those different fields. Now to start moving them around, I can either right click or click the dot, dot, dot and move them up and down through that hierarchy. I'm going to put Category at the top, then Segment, move that one up, and then finally we want Product at the bottom so let's move Product down. I can see Product hierarchy goes Category, Segment, Manufacturer, Product. I could also rename the title of this hierarchy, and typical sort of best practice is actually to hide the remaining fields just so that your users don't get confused between individual fields versus the whole thing. So now any time I use this category, for example to build a new chart—another new column chart— I can drag that entire hierarchy onto our axis. Let's look at the units by category. And you can see by default the chart I get created shows me the top level of the hierarchies, so our Category. And I can drill in— drill up and down through this hierarchy. A couple of different ways to do it. One is you'll see up in the ribbon there's a drill tab, and this gives me options to drill down, drill up, or expand everything. And I can also right click on one of these and drill down or expand everything. If I drill down, I will filter this visual to just the category that I've selected. So in this case I right clicked on Urban. I'm going to drill down just into that category. And I can see the different totals by segment just for that category. In fact if I scroll down in the filter pane, you'll see I've already filtered that down just to the Urban category. So I can keep going. I could right click again on Regular, and I can drill back up if I want to. Or I can drill down into just that Regular segment and see the individual manufacturers. And again, you can see another filter has been added to show I'm looking at just the regular segment. So I can also do that drill up, drill down through the ribbon. I drilled all the way back up to the top. And I have one other option. So as well as drilling into a specific category, I can choose this Expand All option. And what that will do is it will take me down to the next level, so it'll take me down to the segment level. But it'll do it for all of the different categories. So I can see across all of the different categories, I've got a whole bunch of different segments— All Season, Convenience, Extreme, Moderation, et cetera, et cetera. And again here, there's no different filters that have been applied. I've just changed what I'm looking at in the visual from Category to Segment. So that's how you can use hierarchies to navigate and drill up and down through a hierarchy and make it easier for your users to understand what's in this data. The final thing that you can do is actually say, okay well I'm looking at some total unit sales for our Regular segment, 207,000 total units sold. But what about the individual records that make up that number? What are the individual sales transactions or the individual line items in your data set that make up that number? When I right click I can also see this See Records option. It's also here in the ribbon. When I choose that, I'll swap over to a tabular view where I'm looking now at individual segments— individual line items rather— individual line items, individual transactions in your data, the measure for each of those different line items. So you might see some repeated values in here. For example, so you can see this Natura UR-08, we had two sales of this thing at 44 units each. And that's part of the thing that's being added up to the complete total. And go back to the report like this, and I go back to the visualization. So I can drill up and down three categories, and I can also drill down to the very, very detail levels, the individual records within that data.

Video Details

Duration: 4 minutes and 54 seconds
Country: United States
Language: English
License: All rights reserved
Genre: None
Views: 8
Posted by: csintl on Jun 22, 2016

DELETE. This has already been completed. Thanks. need by next Monday. thanks. ----- (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), Spanish (spa).)

Caption and Translate

    Sign In/Register for Dotsub to translate this video.