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.
  • rajendraongole1's avatar
    2 years ago

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