how to display data from particular month onwards

[deeavhad]

My dimension is drill down and the expression are as follows

1. =Month(UKI_ES_Closed) & right(year(UKI_ES_Closed),2)

2.='Week'&Ceil(Day(UKI_ES_Closed)/7)

3. =DayName(UKI_ES_Closed)

I want data to be displayed from Sep 2020 onwards and data before that should not be visible in chart( only this single chart not all the sheet)

[sunny_talwar]

Use set analysis in your expression to exclude data before Sep 2020. May be use Date field or MonthYear field to do this in your expression. For example, If you have a date field in this format MM/DD/YYYY... you can try this

Sum({<DateField = {">=09/01/2020"}>} Measure)

[AshutoshBhumkar]

Hi,

You can use set analysis to restrict the data in chart.

i.e assuming  UKI_ES_Closed as date field and if you want to show data from the current month, you can use below expression.

Sum({<UKI_ES_Closed = {">=$(=Monthstart(Max(UKI_ES_Closed)))"}>}Measure)

Which would tshow data from monthstart of max date

[deeavhad]

my measure is as below which not allowing me to use this 

=(Sum({$<UKI_ES_State={'Closed Complete','Cancelled'}>}UKI_ES_Items)-sum([Accuracy_Internal.No. of EE impacted]))/Sum({$<UKI_ES_State={'Closed Complete','Cancelled'}>}UKI_ES_Items)

how to add this measure to 

Sum({<DateField = {">=09/01/2020"}>} Measure)

[sunny_talwar]

May be this

=(Sum({$<UKI_ES_State = {'Closed Complete','Cancelled'}, UKI_ES_Closed = {">=09/01/2020"}>} UKI_ES_Items)-Sum({<UKI_ES_Closed = {">=09/01/2020"}>}[Accuracy_Internal.No. of EE impacted]))/Sum({$<UKI_ES_State = {'Closed Complete','Cancelled'}, UKI_ES_Closed = {">=09/01/2020"}>} UKI_ES_Items)