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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hi everyone,
I want to make a report where the temperature data from different years is shown related to an specific event that can be changed and must be dynamic. Here I have made an sketch:
The problem is that events occur on different dates each year, and therefore appear offset in the graph:
How can I make the graph center the data by event and have this remain dynamic, that is, vary depending on the selected event?
Here are the tables with the data I am using:
any help will be appreciated!
Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.
Best Regards,
Jayleny
Sure! here are the files:
The result I want is to center the temperature data. I want the event (event must be variable) to stay in the middle of the X-axis and the temperature data to be displayed from 1 to 8 weeks before and from 1 to 8 weeks after the event.