Hi Zhouyi Zhang,
Thank you so such for your support.
i am using 9.3 version. can you please tell how you did it or please attache the .twbx file with 9.3 .
The process or workaround is Same,
what u did is perfect,
Only one thing you need to do is in all the sheets just you add the Region field to colors.
And then add the actions, that you already did it, and hen check the output.
I don't have 9.3 so I show you one sample step for ship mode, and then you can copy the same way to other two worksheets.
Step 1: Create a calculation field as below:
Step 2: Drag the new calculation field to column, and drag Region to your original measure as a color
step 3: use dual axis and synchonize
hide the header
Go back to the dashboard, select a region and then you will see the result.
do the same thing for the other two worksheet.
sheet 3, the calculation should be
Sheet 4, the calculation should be
Hope this could help. and if it works, could you please mark my answer as correct or helpful. Thx.
Thank you ZZ,
I got it. Thank you so much for your support.
Glad it helps.
I didn't see your snapshot, could you send it again?
thanks for your screen shot, it helps me figured out your problem.
I did minor change to the calculation to display the values along with bar.
See my result below
I attached the workbook, hope this could help, please let me know if you have questions.