Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
johntravis667
New Member

Create a Date Slicer with calculated fields starting at new reference date

I'm trying to make some price change comparisons in a dashboard where we have a starting month and show the price changes for the following 12 months based on the price in the first month shown. But I want to include a date slicer that will adjust the period and then recalculate the data based on the new minimum date in the filter. 

 

This is rather simple in Tableau but seems to require a bit more work in Power BI. Has anyone done anything like this and if so how do I set it up? Are calculated fields even the way to go or is there another option?

 

 

 

1 REPLY 1
Phil_Seamark
Microsoft Employee
Microsoft Employee

Hi @johntravis667,

 

You can create powerful caluclated columns and measures to achieve the behaviour you describe.  If you provide some sample data we can help you get started.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors