How to create a report using Excel data in Power BI Workspace with a practical example? It is the Excel workbook that we imported in our previous article.
Before I start creating a report with the Excel file, let me show you the dataset in my Power BI workspace. To see the same, click on Power BI My Workspace and then go to the Datasets tab. In this example, we are using that Global Store Excel dataset and I suggest you refer to the article Upload Excel File.
<>How to create a report using Excel data in the Power BI workspace
Click the Chart (or Visual) button next to the Excel dataset
Please wait until the data is loaded
Clicking the Create button opens the following window. Here you can create your own images.
For demonstration purposes, we created a clustered column chart.
Let me apply a quick format to the clustered column chart. Once you have finished creating a report, click the Save button
By clicking on the Save The button opens a Save your report window. Provide the name of the report.
Inside the Reports tab, you can see the report we created.
