Power BI’s Model view

Power BI’s Model view is known and acknowledged, but there is a lot more it can do for you than simply connecting related values. Keep on reading to find out what 3 of the most useful tips are!

 

Tip 1: Perform multiple actions at once

Let’s say you would like to configure some of your sale values. But in the Report view, you can only take each value at a time and perform that modification. The Model view, however, offers you the possibility of performing the same modification on multiple values at once.

Below, you will find a short demonstration of how to change the summarization of your data from average to none.

HOW TO:

1. Click on Model view

2. Select all the values, for which you want to modify summarization

3. While having all the values selected, expand Advanced

4. Expand Summarize by and select “None”

5. Voila – your selected data is no longer summarized by average and without modifying it one by one!

 

 

 

Tip 2: Hiding values & creating folders for grouping

At times, the tables you upload into Power BI have an overwhelming amount of data and it floods your Fields pane in the Report view. The Model view offers an easy way out! You can hide certain values and then group the ones you want to use into folders.

First, you will learn how to hide values from being displayed in the Report view.

HOW TO: 

1. Click on Model view

2. Select all the unrelated values you want to hide

3. While having all the values selected, expand General

4. Simply click on the “Is hidden” pane and switch it on

5. Now, if you return to the Report view, you won’t see the values in the Fields pane

 

Secondly, you will learn how to group the remaining values into folders.

HOW TO: 

1. Click on Model view

2. Select all the values you want to group into a folder

3. While having all the values selected, expand General

4. Under the Display folder pane, label your folder, for example “measures”

5. Now, if you return to the Report view, you values will be displayed as the folder you labelled

6. To create subfolders, simply select the values you want to place in the subfolder

7. While having all the values selected, expand General

8. In the Display folder pane, add “/” behind the label of your folder and then add the label for your subfolder

If your folder was labelled as “measures” and your subfolder is to be labelled as “sales”, the Display folder pane would read: “measures/sales”.

9. Now, if you return to the Report view, the relevant values are nicely and neatly divided into folders and subfolders

 

Tip 3: Different views of the model

While the Model view offers to link relevant values in individual tables, at times, this wide net of connections is confusing. Our final tip teaches you how to create a focused overview of only your inter-related tables.

Below, you will learn how to create tabs with only your chosen tables and their related counterparts.

HOW TO: 

1. Click on Model view

2. Almost completely down next to “All tabs” , click on “+” to add a new tab

3. In the new tab, select the table you wish to display

4. Right click and select “add related tables”

5. All the tables with values related to the initial table will appear

6. You can label this new tab to reflect the topic of the inter-related tables

7. Now you have a clear and focused overview of the most relevant tables

8. Repeat this process and create a tab for all the relevant tables you want to focus on

 

So there you have it; a short selection of ways you can start using Power BI’s Model view to the fullest – try them out and let us know your thoughts!