Filter by last month

[Amardeep100115]

Hi,

I wish to display upcoming expiry date with taxi root & Taxi no data in data table in visual  after selected month. I have last 8 minths same data with me.

if i selected May 2019 in filter visual then table should be reflect all "Current Expiration Date" data after May 1, 2019 and accordingly table as well.

Sample data is available on below link

https://1drv.ms/u/s!Ai3rGPgy20kLwRosZpa8BCeEw5d3?e=je1U8v 

[v-xicai]

Hi  @Amardeep100115 ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[Amardeep100115]

Could you please share working file

[v-xicai]

Hi @Amardeep100115 ,

You can download my test pbix: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/Ee7QmVopNCJHgsKhG7...

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Amardeep100115]

Hi Amy.

Reuslt should be the filter data as list after selected month/upcoming expiry taxi root. 

[v-xicai · Accepted solution]

Hi @Amardeep100115 ,

You can create column Year & Month , and let it as source of slicer visual.

Year & Month = FORMAT(Sheet1[Current Expiration Date],"MMM yyyy")

To get this sorted correctly , also add the following column.

MonthID = IF(Sheet1[Current Expiration Date]<>BLANK(),INT(format(Sheet1[Current Expiration Date],"YYYYMM")),BLANK())

Once you have created the two columns, you can choose the column Year & Month in Field pane, then sort by column MonthID like picture below.

Result:

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.