Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Small Multiples - Keep time series on X-axis while filtering on sales in past 12 months

Hi everyone, Use case I am trying to build a small multiples chart that only displays combinations of countries and products where there has been at least one sale in the past 12 months.   Chal...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Anonymous , if you want a trend there should not be a filter on the page. If there is a filter then it should be on an independent table

 

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -12) +1
return
calculate( sum(sales[Gross Sales]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

 

 

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI