Forum Discussion

Cardi0z's avatar
Cardi0z
Helper I
2 years ago

Need help to create bar chart base on excel datasource

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

Tutorial Requests

4 Replies

  • SamInogic's avatar
    SamInogic
    Super User
    2 years ago

    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 [email protected]
    Service: https://www.inogic.com/services/
    Tips and Tricks: https://www.inogic.com/blog/
    • Cardi0z's avatar
      Cardi0z
      Helper I
      2 years ago

      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

      • SamInogic's avatar
        SamInogic
        Super User
        2 years ago

        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.