The data stays up-to-date so you can track the latest value at a glance. Now that you've pinned this visualization, it's stored on your dashboard. Select New dashboard and name it Financial Sample dashboard, for example.Ī success message (near the top-right corner) lets you know the visualization was added as a tile to your dashboard. Now you're looking at the report in Reading view. Give your report a name (for example, Financial Sample report), then Save. Hover over the visualization and select the pin icon that appears either above or below it.īecause this report is new, you're prompted to save it before you can pin a visualization to a dashboard. This chart looks interesting, so let's pin it to a dashboard. Select the Line chart icon from the Visualizations pane. Line charts are good visuals for displaying values over time. Let's switch to a different way of displaying this data. Some fields have sigma symbols next to them because Power BI detected that they contain numeric values. No worries! We're going to change the visualization in the next step. If you selected the Date field first instead of Gross Sales, you see a table. We see the Filters, Visualizations, and Fields panes on the right. When your dataset is ready, select More options (.) next to your Financial Sample dataset, then select Create report to open the report editor. If you select Upload, the entire Excel workbook is uploaded to Power BI, where you can open and edit it in Excel Online. Under the Create new content section, select Files > Local File, then select the location where you saved the Excel file.īrowse to the file on your computer, and choose Open.įor this tutorial, we select Import to add the Excel file as a dataset, which we can then use to create reports and dashboards. In My workspace, select New > Upload a file. Select My workspace in the navigation pane.
To begin, open the Power BI service () in your browser.ĭon’t have an account? No worries, you can sign up for a free Power BI Premium Per User 60 day trial Want to follow along? Download the Financial Sample file. In this tutorial, we get data from a simple Microsoft Excel file. This time though, we're going to start from scratch creating a report in the Power BI service. You can transform, shape, and model data, before you start designing reports. Often, when you want to create a Power BI report, you start in Power BI Desktop.
Complete the wizard to get a free license, open the Power BI service (), select the Me icon and choose either Buy Pro now or Try paid features for free. If you don't have a Power BI account, and plan on creating content, sign up for a free Power BI Premium Per User 60 day trial before you begin.
You need a Power BI Pro or Premium Per User (PPU) license to create content in Power BI.