Need help to create bar chart base on excel datasource

[Cardi0z]

Below is my database (excel)

then I want to create a Power BI table and bar chart with visuals like the screenshot that I have shared below

please help me how to do that

thank you

[SamInogic]

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!

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

[Cardi0z]

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

[Cardi0z]

Dear @SamInogic 

I mean, can you help me to solve this problem?

[SamInogic]

Hi @Cardi0z  , 

You are welcome.

If this solution worked for you, could you please mark our answer as accepted solution so that if some others face same issue like yours, it will help them.