Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am very new to Power BI, but I have to present my work in a few days.
As you can see in the table, we have the collums:
- transportID
- created
- amountOfEmails
What I need to present is the total number of mails sent per day in a list and as a bar chart.
Can anyone help me?
PS: At the moment I only got this.
Thank you very much.
qwertzuiop
Solved! Go to Solution.
Hi @qwertzuiop
1. Create an additional column with the date only:
CreationDate = INT( Table1[Created] )
and and convert to Date type
2. Place Table1[CreationDate] in the rows of a table visual and in the axis of a bar chart
3. Place this measure in both visuals:
NumEmails = SUM( Table1[amountOfemails] )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Hi @qwertzuiop
1. Create an additional column with the date only:
CreationDate = INT( Table1[Created] )
and and convert to Date type
2. Place Table1[CreationDate] in the rows of a table visual and in the axis of a bar chart
3. Place this measure in both visuals:
NumEmails = SUM( Table1[amountOfemails] )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
45 | |
28 | |
21 | |
11 | |
8 |
User | Count |
---|---|
77 | |
50 | |
46 | |
16 | |
12 |