PowerBI Report Functions

Access to the BI reports is controlled by the 'Can access business intelligence reports' user group permission. By default, the 'Administrator' user group has access to BI reports.

Select Options and Filter Data

On some pages, you can select specific measures to track from drop-down menus.

select.gif

In addition to the basic filter buttons such as the date filter, some additional filters are also available in the right-hand side filter panel. The following filter types are available:

  • Filters that apply to all pages

  • Filters that apply to the current page

  • Filters that apply to the selected visual

filter.gif

In a bar chart with multiple columns, you can select (and deselect) the columns you want to view by holding down the Ctrl (Windows) or Cmd (Mac) key.

barchart_filtering.gif

View Details

Drill Down to Details

If a chart contains hierarchical data, for example, a date (year, month, day), you can drill down to the next level to view the detailed information. You can drill down to details in the following ways.

(a) Right click on the visual and select Drill down.

drill_down.png

(b) Select the single downward arrow in the top right-hand corner of the visual and select a datapoint on the visual.

drill_singlearrow.gif

(c) Select the double downward arrow in the top right-hand corner of the visual.

drill_doublearrow.gif

View Tooltips

Tooltips also provide detailed information for data points on visuals. Hover over a data point to view the tooltip.

tooltip.gif

Enlarge a Visual

Using the focus mode, you can make a visual bigger. Select the focus mode button in the top right-hand corner of the visual.

focusmode.gif

Export Data to Excel

You can export the data from a report to an Excel file. Select the three dots button in the top right-hand corner of the visual and select Export data.

export.png

Personalise Visuals

You can personalise visuals to see a different view of a particular visual, swap what is on the axis, change the visual type, or add something to the tooltip. You can make the following modifications to visuals:

  • Change the visualization type

  • Swap out a measure or a dimension

  • Add or remove a legend

personalise.gif

Updated

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.