Hello,
I wanted to create a bubble chart with a cagr on X and Y axis.
I want to have two slicers, one for each axis.
For example, X axis I have cagr for year 2000-2010 and on Y axis I have cagr for years 2015-2020.
The current limitation is that I have to have one cagr for years that are also in another. So if one cagr is 2018-2020, I can only choose 2019-2020 or 2018-2019 for other to still have the visualization.
I created new columns in the data set co calculate the cagrs using them - Year X = [year], Cagr X axis, Year Y = [year], Cagr Y axis, but it doesnt matter.
I would appreciate any help with this issue.
Thanks!
