Monday, February 26, 2024

What is Display folder in Power BI. Give an example

In Power BI, a display folder is a feature that allows you to organize and group related measures and calculated columns within the field list pane. Display folders help improve the organization and navigation of measures and calculated columns, especially in scenarios where you have a large number of them.

Here's an example to illustrate how display folders work in Power BI:

Let's say you have a Power BI report for sales analysis, and you've created several measures to analyze sales performance. These measures include Total Sales, Sales Quantity, Average Sales Price, etc. Additionally, you've also created calculated columns such as Profit Margin, Sales Growth Rate, etc.

Without using display folders, all these measures and calculated columns would appear directly in the field list pane, potentially cluttering the view and making it challenging to find specific items, especially as the number of measures and columns increases.

To organize these measures and calculated columns using display folders:

  1. In Power BI Desktop, go to the "Data" view or "Model" view.

  2. Right-click on an empty area within the field list pane.

  3. Select "New Display Folder" from the context menu.

  4. Enter a name for the display folder. For example, you can name it "Sales Analysis."

  5. Drag and drop the measures and calculated columns you want to include in this display folder into the newly created folder.

  6. You can create additional display folders as needed to further organize your measures and columns.

Once you've organized your measures and calculated columns into display folders, they will appear grouped within the field list pane under the respective folder names. This makes it easier to locate and access specific measures and columns, improving the overall user experience and productivity when building reports.

For example, after creating a display folder named "Sales Analysis" and moving relevant measures and calculated columns into it, your field list pane might look like this:

Sales Analysis
   - Total Sales
   - Sales Quantity
   - Average Sales Price
   - Profit Margin
   - Sales Growth Rate

By using display folders, you can maintain a clean and organized structure within the field list pane, making it more intuitive for report authors to find and use the necessary measures and calculated columns during report development.

No comments:

Post a Comment