Risposta

Option 1

Option 2

1. Create a parameter named Max of Axis with the following settings.

• Data type: Integer
• Current Value: enter the preferable maximum value of axes.
• Allowable values: All

2. Click Analysis > Create Calculated Field to create the Reference Line calculated field including the following formula.

   MAX([Max of Axis])
   

3. Place Profit to columns, Segment to rows, and Reference Line to details.
4. Right-click the axis > Add Reference Line with the following settings.

• Scope: Per Pane
• Value: AGG(Reference Line), Maximum
• Labe: None
• Tooltip: None
• Line: None

5. Right-click the Max of Axis parameter > Show Parameter.
6. Open a new sheet and place Sales to columns, Ship Mode to rows, and Reference Line to details.
7. Right-click the axis > Add Reference Line with the same settings of step 4.
8. Open a new dashboard and place Sheet 1 and Sheet 2.

Ulteriori informazioni