Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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!