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'm very new to PowerBI, apologies if this has been answered somewhere obvious. I separated out my data and am trying to get two measures (PPC Leads and Email Leads) in the same chart by month. The "Email Leads" measure seems to be showing the sum of all values for each month instead of the monthly sum:
How can I make "Email Leads" show sums for each month? I've checked the settings and it looks like they're all the same between the two measures.
Solved! Go to Solution.
You need a calendar table to related both tables.
The easy way is Go to Modeling and New Table
MyCalendar=CalendarAuto()
Now related this table (MyCalendar) with PPC Lead Date and Email Lead Date
After that use This Date (in My Calendar) to Axis in your Chart-
Can you please share the Calculations of both measures. ?
I'm not sure how to show that...I don't have any calculations here really, just data sourced from tables. Here is how I have my visual set up:
This is what my data looks like (sources are both text):
They look like this. I constructed the "PPC" and "Email" tables based on filtered data from the "RAW DATA" table. Thanks for the help!
You need a calendar table to related both tables.
The easy way is Go to Modeling and New Table
MyCalendar=CalendarAuto()
Now related this table (MyCalendar) with PPC Lead Date and Email Lead Date
After that use This Date (in My Calendar) to Axis in your Chart-
That worked - thank you very much!
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 |
---|---|
96 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |