Could you please attach sample data.
Am I right, that you have 2 dimensions (PNL and Regions) and 2 measures (Actuals and Operating Profit)? And you want to have PNL in colors?
Do you want to see on the same chart everything, Actuals and Operating Profit by Regions and Actuals and Operating Profit by PNL?
You can create 2 views:
1. Map with Actuals and Profit. You can present Actuals as color of the Region (from Red min to Green max) and Profit as circles (size is representing Profit size)
2. PNL with Actuals as a Bars (split by colors) and Profit as Lines with secondary axis
and put both on one dashboard
On your 2 nd point you are asking to create Profit as lines but due to pnl as color multiple line will come will that be correct?
If you want to see breakdown of Profit by PNL, yes, there are will be multiple lines. Of course, you have to align that colors with the ones in bars for Actuals.
And to decide if it is a good viz for you depends on the number of PNLs. If there are dozens of them, you will need to aggregate them in some way. But if there are up to 5 PNLs, it should be ok.
BTW, do you want to see dynamic from period to period for regions or just a snapshot for specific period?