I have a bubble chart showing different products using values on both axises. Each product has a certain value and quantity in the table. The horizontal axis is the value*quantity, so the more revenue a product is holding the more to the right it's bubble is. The issue is, some products are off the charts comparing to smaller products and since zooming is not available on PBI visuals (huge missing point in my opinion!), I want to give the possibility to the end users to dynamically limit x-axis as a workaround for zooming. A slider on a slicer would be the best. I tried creating a calculated column to calculate the x-axis value for each product and use that as a filter, but it fails to calculate, because the data I have is too much for such calculation, even though I have 64GB memory.
@mafaber - Not really understanding your dilemma. Why can't you just use a range slicer on your x-axis column? If you need to generate a column for some reason, you should be able to use GENERATESERIES with a MAX and MIN of that column for example.