https://community.fabric.microsoft.com/t5/Report-Server/Showing-group-of-dates-filtered-with-slices/m-p/685431#M10227 <P>Hello all,</P><P>I would like to get a line chart of the numbers of sales for a period like this one</P><P><img /></P><DIV><DIV><SPAN>But I'd like to know if I can get the same, filtering the date in a list or dropdown slice, </SPAN></DIV><DIV><SPAN>instead of a range of dates.</SPAN></DIV><DIV><SPAN>This is the measure I'm using:</SPAN></DIV><DIV><SPAN>sales = </SPAN></DIV><DIV><SPAN>CALCULATE(countrows(sales);FILTER(sales;sales[salesdate]&gt;=sales[salesdate]-7 &amp;&amp; sales[salesdate]&lt;=sales[salesdate]))</SPAN></DIV></DIV><P><img /></P><P>Thanks in advance for your help</P> Tue, 07 May 2019 14:13:00 GMT Anonymous 2019-05-07T14:13:00Z https://community.fabric.microsoft.com/t5/Report-Server/Showing-group-of-dates-filtered-with-slices/m-p/685431#M10227 <P>Hello all,</P><P>I would like to get a line chart of the numbers of sales for a period like this one</P><P><img /></P><DIV><DIV><SPAN>But I'd like to know if I can get the same, filtering the date in a list or dropdown slice, </SPAN></DIV><DIV><SPAN>instead of a range of dates.</SPAN></DIV><DIV><SPAN>This is the measure I'm using:</SPAN></DIV><DIV><SPAN>sales = </SPAN></DIV><DIV><SPAN>CALCULATE(countrows(sales);FILTER(sales;sales[salesdate]&gt;=sales[salesdate]-7 &amp;&amp; sales[salesdate]&lt;=sales[salesdate]))</SPAN></DIV></DIV><P><img /></P><P>Thanks in advance for your help</P> Tue, 07 May 2019 14:13:00 GMT https://community.fabric.microsoft.com/t5/Report-Server/Showing-group-of-dates-filtered-with-slices/m-p/685431#M10227 Anonymous 2019-05-07T14:13:00Z