答案

• Build the Bar Chart

1. Create a new worksheet Bar Chart
2. Drag Order Date to Columns
3. Drag Measure Names to Filters card, select Sales and Profit
4. Drag Measure Values to Rows
5. Drag Measure Names to the Color of Marks Card
6. Change the chart type to Bar

• Build the Details crosstab
  1. Create a new worksheet Details
  2. Create a parameter Measure Names Parameter as the following:
  3. Create calculation field Selected Profit

     if [Measure Names Parameter]="Profit"
     then [Profit]
     END

     Create calculation field Selected Sales

     if [Measure Names Parameter]="Sales"
     then [Sales]
     END

  4. Drag Order Date to Columns
  5. Drag Measure Names to Filters card, select Selected Sales and Selected Profit
  6. Drag Measure Values to Text in Marks card
  7. Drag Measure Names Parameter, Category, Sub-Category to Rows
• Set up dashboard actions
  1. Create a dashboard, add Bar Chart and Details to the view
  2. Select from the menu bar, Dashboard>Actions...>Add Action>Change Parameter
  3. Click the Use as Filter button  of the Bar Chart
  4. Edit the generated filter, change the Clearing the selection will: to Exclude all values

其他資訊