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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

Show different dates in diagram



I have a slicer with dates, where I can select only one value.

Then I want to show a measure rolling year (12months before) for selected date and for date a year ago.


my table for slicer is date table and also I have my table with data and column "date" format.


Please help me to write how to choose these dates in filter. Many thanks


Super User
Super User

So, what you will want to do is to make sure that your date table is NOT related to your fact table. Use the date table for the slicer. Then, you will need to write a measure that gets the MAX of your date table and only returns a value if the current date is within your 12 month window, otherwise BLANK. Use the date from your fact table and measure in your visual.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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