Problem shared y-axis in Bar chart and line column chart
I have 4 measure:
1. Quantity --> number
2. KPI-1 --> percentage
3. KPI-2 --> percentage
4. KPI-3 --> percentage
I want to display that to bar chart or line column, but can not grouping or sharing measure for left axis (KPI-1, KPI-2, KPI-3) and right axis (Quantity).
Current problem in screen capture for KPI-3 will be different scale.
example for KPI-3: maximum scale is 80% and for KPI-1 and KPI-2: maximum scales =100%
Left y-Axis: Quantity
Right y-Axis: KPI-1, KPI-2, KPI3 (using shared y-axis/scales)