changing range of x-axis of a line chart using a date range slicer

[Anonymous]

Hi All,

I have a master calendar table with Date,Year, Month, YearMonthShortName and more and a fact table with data from Year 2013 till Year 2018 

I have a date range slicer

I have a trend line chart of sales measure from fact table.

The requirements is as below

 Create a chart such that the date range on the chart changes with the selected range on the date slicer. 

if 2nd of jan 2013 to 1st sept 2014 is selected the date range on the chart reflects same.

if 1st  of jan 2013 to 3rd of jan 2013 is selected date range on the chart reflects same.

The date range of the xaxis will show weeks if the date range selected is less than a month,

The date range of the xaxis will show months  if the date range selected is less than 12 months or more than 12 months 

How do i achieve this .

[Anonymous]

Thanks for the quick response.  

[amitchandak · Accepted solution]

@Anonymous , I doubt as of now you can change axis based on the selected range like time.

You can pass control in had of end-user to choose using field parameters https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd

[Anonymous]

@amitchandak  what about if i want the date x axis  to show 13months backwards of any date selected on the date slier. how do i achieve this.