Level 1 Model Building Exam activity 7

abhishah

Hello There,

 

I am on Activity 7, I am able to bring the REP04 list data as described in the question. However, I am struggling with Page Selector, how can I get those dimension drop downs in text box?

Secondly, I am also struggling with Line Chart, how to get years on X axis and the different colors for the executive, director, so on and so forth. I think I can post the screen shot but I don't want to take a risk of giving away the question.

JaredDolich

@abhishah 

Great questions! 

1. The selectors can be controlled by going into the designer, click on the grid, then select the "context" tab.
2. For line charts and column charts, whatever is in the columns (pivot) will be your X-axis. In the event you have a nested list in the columns the top column will be the x axis.

Almost there! You got this.