Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
We have a simple table like so:
Item, Start Date, End Date, Monthly_Total
It is easy enough to show growth by graphing monthly total by start date.
And its easy enough to show cancels by graphing monthly total by end date.
I want them both on the same graph though. What would be the ideal way to change the data structure to allow this? (In direct query mode)
I had thought about making a new table with just:
Month, Growth, Cancels and just graphing that but In direct query mode I can't add additional tables.
You may add a calendar table at the source and use measures.
You can't create a custom table when using direct query mode.
I've added a calendar to our backend database but am still having issues with the dax forumla.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
66 | |
34 | |
25 | |
22 |
User | Count |
---|---|
97 | |
96 | |
58 | |
45 | |
42 |