Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
JTSantos
New Member

bar chart that shows the sum of records per week with relationship between two tables

‎03-29-2024 03:35 PM

Hi,
I'm trying to create a bar chart that shows the sum of records per week.
The records table is a combination of several Excel tables. This table has the date on which the registration was made, there may be more than one registration per day and there may be no registration on certain days or even weeks. I can't add column to this tables.

record nºDataTipoSector
120556872024-03-29MCPSE-SLP
120556862024-03-29MCPSE-EDF
120556852024-03-29RTSUP
120556842024-03-29RTSUP
120556802024-03-30MPRSLP
120556632024-03-30MPREBT
120556202024-03-28MCPSE-EAM
120554512024-04-01MPRCEE
120554502024-03-28RTSUP
120554492024-03-28RTSUP
120554452024-03-29MPRSLP
120552312024-03-27MCPSE-EDF
120552202024-03-27MCPSE-STB
120552192024-03-27MCPSE-STB
120552182024-03-27MCPSE-STB
120552172024-03-27MCPSE-STB
120552162024-03-27MCPSE-SLP
120552152024-03-27MCPSE-EDF
120552142024-03-27MCSUP
120552132024-03-27MCSUP
120552122024-03-27RTSLP
120552112024-03-27RTEBT
120551982024-04-01MPRPSE-EAM
120551802024-04-01MPRCEE
120551762024-04-01MPRSUP
120548342024-03-29MPRSUP
120548302024-03-28MPRSLP
120547762024-03-27MPRPSE-EDF
120547552024-03-26MPRPSE-STB
120547542024-03-26MPRPSE-STB
120547502024-03-26MPRPSE-EDF

I created an Excel table that transforms the dates in a column into week numbers in column A and year in column C. In Power BI desktop this table is related to the reference table through the date. I use the data table to make other filters.

SemanaDataAno
101/01/20242024
102/01/20242024
103/01/20242024
104/01/20242024
105/01/20242024
106/01/20242024
207/01/20242024
208/01/20242024
209/01/20242024
210/01/20242024
211/01/20242024
212/01/20242024
213/01/20242024
314/01/20242024
315/01/20242024
316/01/20242024
317/01/20242024
318/01/20242024
319/01/20242024
320/01/20242024
421/01/20242024
422/01/20242024
423/01/20242024
424/01/20242024
425/01/20242024
426/01/20242024
427/01/20242024
528/01/20242024
529/01/20242024
530/01/20242024
531/01/20242024
501/02/20242024
502/02/20242024
503/02/20242024
604/02/20242024
605/02/20242024
606/02/20242024
607/02/20242024
608/02/20242024
609/02/20242024
610/02/20242024
711/02/20242024
712/02/20242024
713/02/20242024
714/02/20242024
715/02/20242024
716/02/20242024
717/02/20242024
818/02/20242024
819/02/20242024
820/02/20242024
821/02/20242024
822/02/20242024
823/02/20242024
824/02/20242024
925/02/20242024
926/02/20242024
927/02/20242024
928/02/20242024
929/02/20242024
901/03/20242024
902/03/20242024
1003/03/20242024
1004/03/20242024
1005/03/20242024
1006/03/20242024
1007/03/20242024
1008/03/20242024
1009/03/20242024
1110/03/20242024
1111/03/20242024
1112/03/20242024
1113/03/20242024
1114/03/20242024
1115/03/20242024
1116/03/20242024
1217/03/20242024
1218/03/20242024
1219/03/20242024
1220/03/20242024
1221/03/20242024
1222/03/20242024
1223/03/20242024
1324/03/20242024
1325/03/20242024
1326/03/20242024
1327/03/20242024
1328/03/20242024
1329/03/20242024
1330/03/20242024
1431/03/20242024
1401/04/20242024
1402/04/20242024
1403/04/20242024
1404/04/20242024
1405/04/20242024
1406/04/20242024
1507/04/20242024
1508/04/20242024
1509/04/20242024
1510/04/20242024
1511/04/20242024
1512/04/20242024
1513/04/20242024
1614/04/20242024
1615/04/20242024
1616/04/20242024
1617/04/20242024
1618/04/20242024
1619/04/20242024
1620/04/20242024
1721/04/20242024
1722/04/20242024
1723/04/20242024
1724/04/20242024
1725/04/20242024
1726/04/20242024
1727/04/20242024
1828/04/20242024
1829/04/20242024
1830/04/20242024

 

Labels:
Message 1 of 4
285 Views
0
3 REPLIES 3
lbendlin
Super User
Super User

‎03-29-2024 04:27 PM

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Message 2 of 4
251 Views
0
JTSantos
New Member
In response to lbendlin

‎03-29-2024 04:51 PM

OK,
I added the tables as requested.
I don't have any example of the expected result, it's basically a bar graph with the number of weeks on the horizontal axis and the bars are the result of the sum of records per week.

 

Thanks

Message 3 of 4
246 Views
0
lbendlin
Super User
Super User
In response to JTSantos

‎03-29-2024 05:42 PM

Not sure if a bar chart is the best way to do that but here goes:

 

lbendlin_0-1711759306020.png

 

bar chart count of records.pbix
Message 4 of 4
230 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All