Power BI Date Slicer For Time Frame

Question

Hi Everyone,&nbsp;I have a dashboard that shows bunch of metrics.&nbsp;Some if these metrics are line charts showing values agains date.&nbsp;I would like to add a Date slicer and choose month to change date. For example when I choose october 2023, I want to see dates, upto October 2023.Currently when I filter a month on the slicer, it shows only selected month from slicer.&nbsp;&nbsp;I can do this(showed below) with Before selection on slicer but it's not user friendly. I want users simply choose month from drop down.&nbsp;&nbsp;&nbsp;&nbsp;To sort this out think that I have a simple table with two columns. First column is Date and Second column is Values.&nbsp;I also have a Date Table and created relationship between two tables.&nbsp;Bonus Question:My Final goal is two have last 3 calendar months.&nbsp;I managed to capture last 3 months in visual but I would prefer to do it on measure.&nbsp;&nbsp;Thanks.

amitchandak · Answer

Anonymous , for that you have to use a slicer on an independent/disconnected table 
&nbsp;
//Date1 is an independent Date table, Date is joined with Table new measure =var _max = maxx(allselected(Date1),Date1[Date])var _min = eomonth(_max, -12) +1 return calculate( sum(sales[Gross Sales]), filter('Date', 'Date'[Date] &gt;=_min &amp;&amp; 'Date'[Date] &lt;=_max))
&nbsp;
Need of an Independent/disconnected Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

anonymous · Answer

Thanks Amit,I checked the video but it shows with a between slicer. I want to get rid of before slicer (and not use between slicer)&nbsp; and use only a dropdown slicer to choose Report Month.