Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
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.
Thank you!
Solved! Go to Solution.
Not sure which exact chart do you mean by bubble chart, but to allow end users to change x axis range you could just create a slicer with the Column on the x axis. Something like:
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not sure which exact chart do you mean by bubble chart, but to allow end users to change x axis range you could just create a slicer with the Column on the x axis. Something like:
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@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.
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
@mafaber , you can select bubble chart vizualization and under filter you can adjust it.
Automatically you can use measures that you use in bubble chart.
There are other solutions:
1) filter using slicer
2) create groups of products with similar values
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |