Forum Discussion
Helper IIShow only future months in Matrix visual
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
3 Replies
- amitchandak
Super User
As long as your calendar has month and your measure has data, It will display. Can you explain a bit more
rajanimaddalaHi 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
- v-diye-msft
Community Support
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.
