Hi,
I have a dashboard where I show the cost income ratio by country and the bubble chart is what the management requires.
The size of bubbles work perfectly fine when there are no filters applied. But if I choose only (2 countries for example) the size of bubbles are not matching as per the value.
eg., (UK total cost is 784, France total cost is 734) once we apply the filter only for UK & France the bubble size for UK is becoming 10 X bigger than France and bubble size of France is showing as "Dot". Is there a way to avoid this?
I tried to adjust the bubble size under presentation, I also tried to use some alternatives like [dual (sum(XXX)),Sqrt (sum(XXX))) based on another thread. Nothing helped, looking for some solution. QVF file is attached.
Bubble = Country
X-Axis = Cost per customers
Y-Axis = Cost income ratio
Bubble Size = Cost
