Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Cardi0z
Helper I
Helper I

Need help to create bar chart base on excel datasource

Below is my database (excel)

Cardi0z_0-1717039256054.png



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

Cardi0z_1-1717039522426.png


please help me how to do that

thank you

4 REPLIES 4
SamInogic
Super User
Super User

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.

SamInogic_0-1717073494426.png2. Select the Excel file for which you want to create the Power BI report.

3. Select the Table from the Excel sheet

SamInogic_1-1717073602536.png4. 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.

SamInogic_2-1717073624360.png

5. Select the table from the Visualizations and add the columns which you want to show in the report

SamInogic_3-1717073655866.png6. 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,

SamInogic_4-1717073690881.png

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/
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/

Dear @SamInogic 

Below is my data source

DATA SOURCE

Cardi0z_0-1717382036003.png


from the data above, how to use power query to calculate the data and display it as the table below

RESULT 1

Cardi0z_1-1717382104841.png


RESULT 2

Cardi0z_2-1717382134954.png


RESULT 3

Cardi0z_3-1717382182950.png


Thank you so much

Dear @SamInogic 

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

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.

 

 

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/

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Solution Authors