Skip to main content

Hi,

 

So, I have a project on my hands that I need some help with. To describe more about the workbook attached, I was given a data set that holds the pollen count for a particular city. I was instructed to create a dashboard that displays the moving average for the different type of pollen grains and the user must be able to make a multiple year selection and the line graph must have a different series for each year selected. I managed to create a parameter to switch between the types of grains but as shown in the attached screenshot, I couldn't get it to display different series when a different year was selected. With a constant "DAY(Date)" on X-axis and Filter "Year" I need some help figuring out how I can display different series of line graph for different year selection. Instead of it displayed side by side as shown in the screenshot, I need help figuring out how to display it one on top of the other for the users to be able to compare the moving averages for multiple years.

 

Thank you in advance for the help.

7 件の回答
0/9000