Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In addition to filters, you may also highlight information. This will not remove unrelated information but will focus on a specific set of data, and dim other data. While in Reading View, you may use multiple filters and highlights across your data sets. Selecting more than one filter will apply both filters to your data. For example, if you would like to filter a Portal Growth report by department and time range, and filter using fields labeled "Marketing" and " D2016," then you will see all Portal Growth and activity from the Marketing team during the year 2016.

Portal Tree Hierarchy

The easiest way to scope any report to a specific site collection (or a specific subsite , library, list, etc) is to add the Hierarchy Slicer visual to the report:

  1. Make sure you are working on a copy of the report (and not the original), then click on Edit report from the top menu:

    Image Added

  2. Open the Visualizations menu on the right, and select the Hierarchy Slicer visual:

    Image Added 
     
  3. In the Fields menu, expand SharePoint Tree and drag SP Tree Hierarchy into the visual's Fields:

    Image Added 
     
  4.  This will add a visual representation of the portal structure that you can use as slicer. To filter the report, expand the tree to find the part of the portal you are interested in, and mark the box next to it. That will automatically filter all the visuals in the report to reflect on that particular part of the portal.

    Image Added 

Ask Your Data Questions

Power BI integrates robust search features that allow you to ask natural language questions that it will interpret and use to actively filter and sort your data. Upon entering any text in the Question field at the top of your report, Power BI will immediately begin offering common suggestions. You may either select a sample question, or continue typing to complete your question phrase. If a dedicated widget does not already exist for the metric you are searching for, Power BI will automatically create a new report widget based on your question terms. 

...