Forum Discussion
Need help to create bar chart base on excel datasource
Hi Cardi0z
If you want to create the table and bar chart using the Excel data source follow the below steps:
1. Firstly, add the Excel data source in the Power BI using the Excel Workbook.
2. Select the Excel file for which you want to create the Power BI report.
3. Select the Table from the Excel sheet
4. Once the Table is Loaded then you will get to see the Tables of Excel sheet in the Data window on the Power BI Desktop.
5. Select the table from the Visualizations and add the columns which you want to show in the report
6. For the Bar chart select the Bar Chart from the Visualizations and add the columns for which you want to show the data in the chart.
7. Below is your final report based on your needs,
Thanks!
An expert technical extension for your techno-functional business needs
Drop an email at [email protected]
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/
Dear SamInogic
Below is my data source
DATA SOURCE
from the data above, how to use power query to calculate the data and display it as the table below
RESULT 1
RESULT 2
RESULT 3
Thank you so much
