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
buletpruf
New Member

Timeline visual date selection to display last week/month/year data on a visual

Hi all,

 

I have sales data for this year and in my dashboard I put a Timeline (Year/Quarter/Month/Week/Day) to select a period.

 

What I'd like to display is the month and week sales in relation to the period I select.

 

For exemple : week 1 to 10 selected in Timeline visual -> I want the Week 10 sales and the March sales to be displayed on 2 different visuals.

 

One thing I tried is to put a Relative Date filter on visuals (Last 1 Week/Month > Today included) but PowerBI takes the date from today and dosn't care about the period I selected.

 

Second thing I tried is to put a Segment with same filter as before put same issue : today's date is taken instead of Timeline visual period selection.

 

Can you help me ?

 

Thanks

1 REPLY 1
lbendlin
Super User
Super User

What I'd like to display is the month and week sales in relation to the period I select.

Weeks and months are incompatible.  

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.