Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi everyone!
I am trying to build a line graph where I have the following data:
- Y axe: Total Sales
- X axe: Days of the week (Monday, tuesday, etc.)
- Line A: Last week sales
- Line B: Previous last week sales
I was able to manage almost everything but I cannot seem to get both values in the same graph.
Can you help?
Thanks a lot!
Solved! Go to Solution.
Hi Freeman,
At the end I went for this:
Hi !
Thanks for your quick answer. All good except, I dont have the WEEK option, only MONTH; YEAR, DATE, QUARTER, I guess I need to create it?
Thanks a lot for your help!
You are right, there is no WEEK interval. You can try -7 DAY and -14 DAY.
Unfortunately, that would run weeks and not "calendar weeks" (from monday to sunday only)
What does that mean? Could you please provide a screenshot or upload the simplified report?
Hi Freeman,
At the end I went for this:
Glad to hear that. With WEEKNUM, we even don't need the Date table, bravo!!!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
21 | |
21 | |
19 | |
13 | |
12 |
User | Count |
---|---|
41 | |
29 | |
23 | |
22 | |
22 |