How to show data in dashboard for latest month only

[Kamaizziati]

Hi All,

I have data based on date but I want only to show a data for the latest month of date.

From below example, I only want to show the data of January 2018.

Example data:

Date	Revenue Item	Revenue Value	Revenue Description
1-Jan-17	A	123	Done
1-Feb-17	B	456	Not Done
1-Mar-17	A	789	Done
1-Apr-17	B	1122	Not Done
1-May-17	A	1455	Done
1-Jun-17	B	1788	Not Done
1-Jul-17	A	2121	Done
1-Aug-17	B	2454	Not Done
1-Sep-17	A	2787	Done
1-Oct-17	B	3120	Not Done
1-Nov-17	A	3453	Done
1-Dec-17	B	3786	Not Done
1-Jan-18	A	4119	Done

Thanks

[Ashish_Mathur]

Hi,

You may drag the Date field to the Visual Filter section and select Relative date filtering there.  See image below

[Kamaizziati]

Hi @Ashish_Mathur,

Thanks for the solution. I try it and successful but I cannot do my filter to see previous month value.

Thanks

[Ashish_Mathur]

I do not understand.

[Kamaizziati]

Hi @Ashish_Mathur,

The latest value is January 2018, its show perfectly.

But when do a selection to see the previous month is december 2017, the data is blank.

[Ashish_Mathur]

Do not change the Year via the slicer.  Change the date in the visual filter.

[Kamaizziati]

Hi @Ashish_Mathur,

When I do selection month, its blank.

[v-yuta-msft]

Hi Kamaizziati,

As @Ashish_Mathur has mentioned, you can not use visual level filter after you use slicer because the result of slicer will be applied to the visual level filter.

To achieve your requirement, you just need change 1 with 2 in visual level filter like below:

The result is like below:

Best Regards,

Jimmy Tao