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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Currently I have a calendar table that show every date of the year and another column telling me what week it is for that year.
Calendar table
| date | week of year |
| 1/1/2023 | 1 |
| 1/8/2023 | 2 |
| . | 3 |
| . | 4 |
| . | 5 |
| 2/6/2023 | 6 |
I have a multiple dates table that also has many dates with time and another column with the number of people.
| multiple dates | time | num of people |
| 1/10/2023 | 11 am | 4 |
| 1/10/2023 | 2pm | 2 |
| 2/6/2023 | 4pm | 3 |
The calendar table has a one to many relationship using date to multiple dates.
Currently I am using a line chart to show how many people are on each date and time.
I would like to add vertical lines for every week. I tried adding my week of year column as an x axis constant line but that does not seem to work. Every time i add it under "what field should we base this on?" it stays blank with no value.
Could someone point me in the right direction on how i can do this if possible?
Thank you
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!