Filtering

[Kumail]

I have a report with category and date filters.

When any date is selected, the report filters and shows data of relevant category for that date, however, I want to add previous won data to be shown also. For e.g. when Juy 12 is selected, it should show

Stage	Volume (AED)
qualify	815776
won	500000

 Can anybody suggest possible ways.

[v-yuezhe-msft]

Hi @Kumail,

Do you also want to show won data of June 30 and data of the filtered date when you filter date to August and later months? If so, I am afraid that you are not able to achieve the requirement.

The closest method I can think of is to show all the stage data that contain the won data before the filtered date. I make a test using the following sample data.

In this case, firstly, you can create another table as follows. Please note that don’t create any relationship between this new table and your original table.

Secondly, in your original table, create a measure in your original table using DAX below.

checkmeasure = IF(MAX(test1[Index])>(MAX(test2[Index])-6)&&MAX(test1[Index])<=MAX(test2[Index]),1,0)

Thirdly, create a slicer using Month field in the new table, and drag the CheckMeasure to the Visual level filters of table visual and filter the measure to 1 only. This way, when you select date in the slicer, table visual will show value for current date and all the stage data that contain the won data before the filtered date.

Thanks,
Lydia Zhang

[Kumail · Accepted solution]

Thanks