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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Employee
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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.