show recent month data

Question

How to display data for recent or latest month in the chart without filter?

Answer 1

Create a calculated column as below,

IF MONTH([Date]) = MONTH({MAX([Date])}) THEN [Date] END

Place year in filter shelf for the year else use YEAR([ Date]) = YEAR({MAX([Date])}) to fetch for latest year.

Drop the created column in the chart and place the other fields to see only the data for the last or recent month.