How to Hide Current Month Details in a chart

[SantoshKumar]

Hi All,

I have Few Charts as follows where i display Data for all the months, but i need to provide a condition so that it will not show details excluding current month.

For example: Since it is June month running so my below chart should show details upto May only by excluding June data.

i have tried the option like : Filters in Visualization but they are getting reset once i close and open the report again.

Could i get any help on it.

Thanks

Santosh

[v-yulgu-msft · Accepted solution]

Hi @SantoshKumar ,

You can create a measure similar to below, add it to visual level filter of the chart and set its value to 1.

Measure= IF(MAX(Sample1[Date])<DATE(YEAR(TODAY()),MONTH(TODAY()),1),1,0)

Best regards,

Yuliana Gu