I think I can provide solutions but 30MB size file makes me to hesitate to start with.
Are you able to reduce the size of file down to 2 MB with filtering the data source?
I have replace a new attachment file which is much smaller, around just 300kb.
Much appreciate if you can help me with this matter, thanks!
I hope this helps
Create Parameter with month Name.
if [Month parameter]=[Month@ Travel] then "show" else "hide" end
// Not sure this filter is needed or not
[Sales in 12 month before]
if datediff('month',[Sales Date],[Travel Date])<=12 then "In 12 months" else "Before 12 months" end
// Date Normalized to 2015 dates
[Sales date Normalized]
date(dateparse("yyyyMMMMMd","2015"+datename('month',[Sales Date])+str(day([Sales Date]))))
Sales trend comparison_SM_10.1.twbx 303.7 KB
You inspire me by such bright idea which finally resolve my problem!
You are welcome
And could you mark my answer as correct.