Create parameter from "date" field
if [Date]=[Parameter 1] then [Value] END
[Date Filter] // put this to column and filter
if dateadd('week',8,[Date])>=[Parameter 1]
then [Date] END
Then put two sheets in Dashboard.
Pie_and_Line_9.2.twbx 55.4 KB
Thank you Shin
1 of 1 people found this helpful
You are welcome.
Could you mark my answer as correct?
How do we take the top 10 categories and other in pie chart. And top 10 categories should change with date,category etc. filter is it possible?
Could you attach packaged workbook(***.twbx) to share your data?