Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
86 | |
84 | |
52 | |
37 | |
23 |