Show only future months in Matrix visual

[rajanimaddala]

Hi,

I am struggling to filter my table visual.

I have a sliver(FY) and a measure.
Measure is to calculate Sales created last 12 months from today.
Sales Qty Last 12 Months =
var StartDate = DATE(YEAR(TODAY())-1, MONTH(TODAY()), day(TODAY()))
RETURN CALCULATE(COUNT(PipelineForecasting[DB_Key]), FILTER(ALL(PipelineForecasting), PipelineForecasting[Transaction Date] >= StartDate && PipelineForecasting[Transaction Date] <= TODAY() && PipelineForecasting[Source] = "OPPS CREATED" && PipelineForecasting[Product Group] IN VALUES(PipelineForecasting[Product Group]) && PipelineForecasting[Sales Person] IN VALUES(PipelineForecasting[Sales Person])))

And another measure Sales Revenue Current MOnth = SUMX(FILTER(PipelineForecasting, [Source] = "WON OPPS"), [Value_NET])

I have pulled this into Matrix visual. Month_Name in Columns

[Transaction Date] is directly related to Date column in Calendar. Month Name in columns is pulled from Calendar table

Our organization FY starts from Aug to Jul

I need to show only future months in the matrix visual. How can I do this?

Thanks in advance

[v-diye-msft]

Hi @rajanimaddala 

you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.

[amitchandak]

As long as your calendar has month and your measure has data, It will display. Can you explain a bit more

[rajanimaddala]

Hi amitchandak,

  Thabks for the reply. As I said I just want to show only future months.

Currently showing all the months from Aug to Jul as our FY starts from Aug to Jul

Regards