Design and implement role-playing dimensions In some cases, there may be more than one way to filter a fact table by a dimension. In the Wide World Importers example, the Sale table has two date columns: Invoice Date Key and Delivery Date Key, both of which can be related to the Date column from the […]
Choose an appropriate visualization type Besides the Table and Matrix visuals, which we used earlier in the book, Power BI offers over 30 built-in visuals. You can see a fragment of the Visualizations pane in Figure 3-1. FIGURE 3-1 Standard visuals in Power BI. In this section, we review the visuals and show you how […]
Skill 3.1: Create reports A Power BI report can be based on only one dataset, and a report may have several pages. Reports can be authored both in Power BI Desktop and the Power BI service. We start this section by reviewing various visualization items and formatting options available for Power BI reports. We also […]
Line and area charts Power BI has a line chart and two types of area charts: These charts have the following common field wells: Area charts are similar to the line chart but have a shaded area under the lines. Additionally, the line and area charts have the Secondary values field well, which allows you […]
Ribbon chart The ribbon chart is like a column chart with ribbons between the columns used to highlight changes in the relative ranking of categorical items. The item with the highest ranking will be displayed on top. The chart has four field wells: Tooltips in ribbon visuals will show additional information compared to the visuals […]
Define a relationship’s cardinality and cross-filter direction In the previous section, we looked at how you create relationships between tables. In this section, we review the concepts of cardinality and cross-filter direction of relationships. You can edit a relationship by double-clicking it in the Model view. For example, in Figure 2-4 you can see the […]
Funnel The funnel chart is like a bar chart with bars centered, and it has three field wells: When you hover over a categorical item in a funnel chart, you see a tooltip with the proportion that category makes up of the first and previous items. It also shows the size of the last item […]
Pie and donut charts The pie chart and the donut chart are the same except the latter has empty space in the middle. Both charts have the same four field wells: When hovering over a slice, you’ll see the proportion it makes up. You can see both pie and donut charts in Figure 3-9, with […]
Create a common date table By default, Power BI creates a calendar hierarchy for each date or date/time column from your data sources. Need More Review? Auto Date/Time Hierarchies For detailed considerations and limitations of the auto date/time feature, see “Auto date/time guidance in Power BI Desktop” at https://docs.microsoft.com/en-us/power-bi/guidance/auto-date-time. While these can be useful in […]
Skill 2.2: Develop a data model Data model development refers to enhancements you add to your model after you’ve loaded your data and created relationships between tables. In this section, we review the skills you need to create calculated tables, calculated columns, and hierarchies, and we demonstrate how to configure row-level security for your report […]
