Forum Discussion

learner_23's avatar
learner_23
Frequent Visitor
2 years ago

help for beginner power bi

Hi,   I am new here. I am struggling with the requirement to create a simple bar chart and table. I attached excelsheet. Sheet 1 is my data and sheet 2 is expected visualization. Can help to create...
Need Help
Show and Tell
AnalyticsWizard's avatar
AnalyticsWizard
Solution Supplier
2 years ago

learner_23 

Sure, I’d be happy to guide you through the process of creating a bar chart and table in Power BI using your data. Here are the general steps:

  1. Load Data: First, load your data into Power BI. You can do this by clicking on “Home” > “Get Data” > “Excel”. Navigate to your Excel file and select the sheet that contains your data.

  2. Transform Data: If your data needs to be unpivoted, you can do this in the Power Query Editor. To open the Power Query Editor, click on “Home” > “Edit Queries”. Select the columns you want to unpivot, then right-click and select “Unpivot Columns”.

  3. Create Bar Chart: Once your data is in the correct format, you can create a bar chart. Click on the “Bar chart” icon in the “Visualizations” pane. Then, drag the fields you want to use onto the “Values” and “Axis” areas.

  4. Create Table: To create a table, click on the “Table” icon in the “Visualizations” pane. Then, drag the fields you want to include in the table onto the “Values” area.

Remember, the exact steps might vary depending on the specifics of your data and what you want your visuals to look like. If you can provide more details about your data and the issues you’re encountering, I might be able to provide more specific guidance. 😊