Is this what you're talking about?
If so, I created a parameter called [Select Region] based off of [Region] --> right click [Region] and create parameter.
Then I created a calculated field called Selected Region's Profit with if [Select Region]=[Region] then ([Profit]) END
Now, you can drag [Profit] and [Selected Region's Profit] to rows and Region to columns, right click the pill for [Selected Region's Profit] and select dual axis. Lastly, right click on any axis and synchronize the axes.
Hope this helps!
1 of 1 people found this helpful
Exactly this I was talking about.