Basic Power BI Editing Elements

Basic Power BI Editing Elements

The first step to editing a report is to clone an existing report. Choose a report that closely resembles the style and content of the report you're trying to create. Directions to cloning a report can be found here

Editing Elements

The right portion of the screen contains the editing elements. There are three columns in the editing elements section – Filters, Visualizations, and Fields.

mceclip1.png

 

Fields

The Fields section contains the available measures and attributes in your implementation. You can add measures and attributes from the Fields section to your visualizations. These attributes come into the visualizations as Rows, Columns, and Values. Rows and Columns contain attributes such as Market Name and Manufacturer. Values contain measures. Measures are depicted in the Fields section with a small calculator. The attributes are shown with a grid icon.

The measures and attributes are grouped by type in folders so that you can easily find the element you need. The folders shown in yellow contain elements that have already been used in the report. 

mceclip4.png

You can also search for a specific elements by using the search field. 

mceclip3.png

Hover over longer names in the fields section to view the full name. 

mceclip2.png

 

Visualizations

The Visualizations section controls the type of visualization you wish to use and the attributes and formatting of those elements. Types of visualizations include tables, graphs, and maps with many variations to select from. 

mceclip5.png

Once you've selected the type of visualization you want to use, you can select the elements to include on Rows, Columns, and Values. Each visualization has different options for how the Fields elements will be displayed. These options change depending on the type of visualization you select. Remove an element by clicking the X next to the name. Add an element by dragging it to the desired Row, Column, or Value section. You can order the elements by clicking and dragging from the Fields section. 

mceclip6.png 

Filters

Filters are often minimized on the screen. Expose the filters section by clicking on the arrow above the Filters section on the right side of the screen.

mceclip7.png

Use the scroll bar to see all the filters on the report. There are three types of filters – "Filters on this visual", "Filters on this page", and "Filters on all pages". The section for "Filters on this visual" is only available when a visual is selected and contains the attributes you choose for Rows, Columns, and Values. Add filters by dragging attributes from the Fields section to the “Add data fields here” beneath the filter type you want to add.

mceclip10.png

 


    • Related Articles

    • Export Power BI Visuals

      Power BI report visuals can be exported from the Portal to your local machine. An entire report can be downloaded as a PowerPoint deck, you can export it as a PDF file, or as individual images (downloaded as a zip file). Individual report pages can ...
    • Power BI - Managing Content with Power BI Folder Management Tool

      Customers with Power BI can manage their reporting content using our Power BI Folder Management tool. Creating folders is one method to help your end users easily find the reports that are most relevant to them. The Power BI Folder Management ...
    • Create/Delete a Clone of a Power BI Report

      Creating Cloned Reports TABS Insight portal allows you to clone existing Power BI reports so that you can edit them to suit your needs. The directions below outline how to clone an existing Report. NOTE: Only users with Creator level access can ...
    • Edit an Existing Power BI Report

      If you have author permissions in the platform you can edit reports.  Log onto the portal and choose a report to edit.  Click the Edit button in the upper right corner of the screen. The model field and visualization selection panels will appear.  ...
    • Accessing Excel Files in the Portal and Editing Steps

      Steps to Download Content and Sign into Connected Excel Make sure your version of Excel meets the requirements, here.  Log into the Portal and click the Files tile in the landing page.  Hover over an Excel file to download and click it to download.  ...