Forum Discussion
Post ProdigyExtreme Values, percentile or std deviation as filter
Hi ElliotP,
Actually, there is a right-angled triangle for every bubbles. So the length of "C" is the distance from every bubbles to the Origin. I call it Radius. The X-axis and Y-axis are numeric most of the time. So we can calculate the Radius and filter the bubbles by Radius. I just display a demo by setting it to "be greater than 30000". You can change it to any number.
If you have some special scenario, please post a sample in TEXT mode. The PBIX file would be great.
Best Regards!
Dale
Post Prodigyv-jiascu-msftThat's incredible idea and the exact thing I was looking for.
What does Radius do exactly, in terms of setting it to be greater than 300k?
Microsoft EmployeeHi ElliotP,
Actually, there is a right-angled triangle for every bubbles. So the length of "C" is the distance from every bubbles to the Origin. I call it Radius. The X-axis and Y-axis are numeric most of the time. So we can calculate the Radius and filter the bubbles by Radius. I just display a demo by setting it to "be greater than 30000". You can change it to any number.
If you have some special scenario, please post a sample in TEXT mode. The PBIX file would be great.
Best Regards!
Dale
- ElliotP
Ah ok, I thought I understood that part. From a practical standpoint, how does radius discern the datapoints it shows? Just datapoints which have a radius say greater x for example?
I just realised this, sorry for being a dill, you can use the radius to set the bounds for radius values; meaning; if radius is less than x but greater than y I can achieve the bounding idea.
Thank you so much, that's an incredible idea.
- v-jiascu-msft
Hi ElliotP,
My pleasure. Just a tip, if you want to set a upper and a lower bounding, you can drag Radius into the "Visual level filter" again. Then there will be two Radius.
Best Regards!
Dale