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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
avinash2807
Regular Visitor

Line Graphs to Show fixed Start and End Date when report loads and Change after slicer selection.

I have a 2 line graphs showing weekly and monthly trends in my report , where in I need to show only fixed start and end dates ( Current Month+ Last 6 Months for monthly and last Current Week + Last 6 weeks for weekly) when the report loads.

when report loads 

 

avinash2807_0-1660077413553.png

however when the user selects slicer only then graph should reflect the months based on user selection. other wise it should stay with same start and end dates when report is loaded.

change in the graph after user selection is anyways happening now , but the point of showing current month + last 6 months by default is something I am not able to acheive , any help ??

avinash2807_1-1660077515330.png

 

avinash2807_2-1660077586145.png

 

I have a separate date table with MonthName , Linked to Measures table through date column.

2 REPLIES 2
avinash2807
Regular Visitor

@daXtreme book mark is kind of static right, where I would be seeing data for a fixed dates.

what I want is to show last currentmonth + last 6months where dates are dynamic .

daXtreme
Solution Sage
Solution Sage

@avinash2807 

 

Creating a bookmark with the initial setting and then setting the report to show what's been saved in the bookmark does not do the job?

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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