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 […]
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 […]
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 […]
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 […]
Creating tables that are based on data from different data sources Sometimes—for example, when creating a bridge table—you may need to extract distinct values from more than one table because the distinct values may be different in different tables. In that case, you’d need to take distinct values from both tables, and if they come […]
Create calculated columns Calculated columns are columns you create by using DAX. Similar to calculated tables, calculated columns can only use the data already loaded into the model or new data generated by DAX, and they don’t appear in Power Query Editor because they are generated after the data has been loaded into the model. […]
Implement row-level security roles A common business requirement is to secure data so that different users who view the same report can see different subsets of data. In Power BI, this can be accomplished with the feature called row-level security (RLS). Row-level security restricts data by filtering it at the row level, depending on the […]
Viewing as roles in Power BI Desktop In Power BI Desktop, you can check what the users with specific roles will see even before you publish your report to the Power BI service and assign users to roles. For this, once you have at least one role defined, select View as on the Modeling ribbon […]
Teach Q&A The Q&A visual didn’t understand the term units because it doesn’t appear in the Wide World Importers data model. The Q&A visual underlines in red the terms it doesn’t understand. If you select units in the Q&A visual, you may be given suggestions to replace units with another term or to define the […]
Removing filters There are several DAX functions that you can use as CALCULATE modifiers to ignore filters, one of which is ALL. ALL can remove filters from: Important Sort By Column and ALL If you’re removing filters from a column that is sorted by another column, you should remove filters from both columns—otherwise, you may […]
