Feature | Description |
---|---|
Get data from a variety of sources (files, databases, online services) | |
Shows most recent sources of data used | |
Creates a new table to store information. Use to quickly enter in some info to a new table. | |
Opens up the query editor to connect and transform data | |
For specific online services, it creates a report template with your data | |
View business dashboard demos and reports across a wide range of industries. | |
New Page | Create blank page or duplicate page |
Textbox/Shapes/Images | Add text and styling to your reports |
Edit the relationships between your data sets such as cardinality and cross filter direction | |
Define a calculation that is not stored but calculated on the fly by row aggregation | |
Publish your data set to Power BI service online to share and schedule reports | |
Apply the format and styles from one graph to another |
Name | Description |
---|---|
|
The power BI canvas. (i.e main view where you make your visuals) |
To see the underlying data and columns | |
Where you join tables together | |
Arrange visuals choose how it appears on a mobile device | |
Show gridlines or snap objects to grid to style your report |
Name | Description |
---|---|
Define a calculation that is not stored but calculated on the fly by row aggregation | |
Define a new column (aka calculated column) in your table | |
Creates a new table with one or more columns. | |
Choose how to sort column, or to sort based on another column in table. (ie. Month number, month name). | |
The format of your data (i.e currency, decimal, percentage) | |
Common data types include decimal number, fixed decimal number, date, text, boolean | |
Displays which table a measure was defined in | |
Applies a label to your column name for clarity or organization | |
Choose how to display columns in a dataset (don't summarize, sum, avg, min, max, count, count distinct) |
Name | Description |
---|---|
Specify which filters and slicers will effect a visual. (Default: slicers and filters apply to all graphs and visuals on a page). | |
|
Visual will remain in front of another visual.(i.e arranges the z-index) |
Visual will remain behind another visual(i.e arranges the z-index) | |
Helps you position and arrange your visuals vertically and horizontally |
Name | Description |
---|---|
Shows all record corresponding to the level of the visualization | |
Shows all data grouped together associated with that level | |
Shows all data in the next level, but ungrouped. | |
Drill up or down on a specific section of data. For instance from year level drill down to quarter, month or day level for that specific year | |
Shows all records for a specific select group | |
Create a group in the fields section to group together multiple data dimensions. |