Forum Discussion

Cardi0z's avatar
Cardi0z
Helper I
2 years ago
Solved

Need help to create bar chart

I want to create report using bar chart on power bi with data source from spreadsheets.

please help me how to do that.
thank you so much.

  • Hi Cardi0z - 

    Ensure your spreadsheet data is well-organized, with headers in the first row and no empty rows or columns.
    Save your spreadsheet in a commonly supported format such as .xlsx or .csv.
    Open Power BI Desktop:

    Hope you have Power BI desktop installed, Launch Power BI Desktop on your computer Import Data from Spreadsheets:

    Click on Home in the top ribbon Select Get Data >> Excel >> Browse and select your spreadsheet file, then click Open.
    you can see Load Data In the Navigator window, select the sheets or tables you want to import.
    Click Load to import the data into Power BI.
    Create a Bar Chart:

    Once your data is loaded, go to the Report view
    On the right side, in the Visualizations
    pane, click on the bar chart icon to create a new bar chart visual.Add Data to the Bar Chart:

     

    In the Fields pane on the right, expand your imported data table to see the columns.
    Drag the desired fields to the appropriate wells in the Visualizations pane:
    Axis: Drag the field you want to display on the horizontal axis (e.g., Category).
    Values: Drag the field you want to measure and display on the vertical axis (e.g., Sales).

     

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!

2 Replies

  • Uzi2019's avatar
    Uzi2019
    Community Champion

    Hi Cardi0z 

     

    You can simply use cluster bar chart

     

     

    But you cant have legends when you are putting 3 different values Month, full MT, RP value.

    If you are putting single value then you can have legends.

     

     

  • Hi Cardi0z - 

    Ensure your spreadsheet data is well-organized, with headers in the first row and no empty rows or columns.
    Save your spreadsheet in a commonly supported format such as .xlsx or .csv.
    Open Power BI Desktop:

    Hope you have Power BI desktop installed, Launch Power BI Desktop on your computer Import Data from Spreadsheets:

    Click on Home in the top ribbon Select Get Data >> Excel >> Browse and select your spreadsheet file, then click Open.
    you can see Load Data In the Navigator window, select the sheets or tables you want to import.
    Click Load to import the data into Power BI.
    Create a Bar Chart:

    Once your data is loaded, go to the Report view
    On the right side, in the Visualizations
    pane, click on the bar chart icon to create a new bar chart visual.Add Data to the Bar Chart:

     

    In the Fields pane on the right, expand your imported data table to see the columns.
    Drag the desired fields to the appropriate wells in the Visualizations pane:
    Axis: Drag the field you want to display on the horizontal axis (e.g., Category).
    Values: Drag the field you want to measure and display on the vertical axis (e.g., Sales).

     

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!