Need help to create bar chart

[Cardi0z]

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 · Accepted solution]

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

[Uzi2019]

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.