Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
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!
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
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
13 | |
8 | |
8 | |
7 |
User | Count |
---|---|
17 | |
13 | |
7 | |
6 | |
6 |