Forum Discussion
Helper IScatter Plot - Dax options to make selected data point more distinguishable
Hi Community, I have a scatter plot with a measure to highlight a selected data point using this approach:
It solved like 80% of my data points, but I have a concentrated data in a few areas where it does not work. Tried using category method and a few others, but there is too much overlap in parts of the data. With regards to the measure below, any way to move the selected value to the front so I can see the Red, or change the size / shape to make the selected value more distinguishable? Thank you!
Red Selected Color = IF ( SELECTEDVALUE ( Slicer[Column] ) = SELECTEDVALUE ( Table[Column] ), "Red" )
Hi ccjj ,
I uploaded another pbix using your sample data. The bubble size will change only if customer "AA" is selected.
https://drive.google.com/file/d/1SYTQ8aVfnWJa3CnM_xI8ND7eUnargsmo/view?usp=sharingHi ccjj ,
Here's the updated pbix: https://drive.google.com/file/d/1SYTQ8aVfnWJa3CnM_xI8ND7eUnargsmo/view?usp=sharing
Please note that there are multiple approaches to removing duplicates and one may be better than the other depending on your use case:- Removing duplicates in Power Query
- Creating a calculated table using DISTINCT function
- Creating measures that will aggregate just the unique items
15 Replies
- danextian
Super User
Hi ccjj ,
Ther is an option to change the size of the bubbles in the scattergraph.
You can use the measure below to dynamically change the bubble size when the selectedvalue is RedMeasure2 = IF ( SELECTEDVALUE ( Table[Column] ) = "Red", [Orignal Measure] * 3, //you can use a different number here [Original Measure] )If this solution doesn't work for you, please post a sample pbix so it will be easier for me or other users to provide you with a working solution or one that is closer to your requirements.
ccjjThank you! tried that and it changed my scatter graph to (1) no Fill (2) did not change the size of the datapoint. Let me see if I can create some sample data and recreate this in PBI
- danextian
Hi ccjj ,
After testing myself the formula I initially recommended for the size, it turned out it wouldn't work as plot sizes are just too big. So I changed it to somethign like IF(SELECTEDVALUE(tbl[column] = "Red", .0000001, 0 ). The bubble size is more doable but could still be too big. I am attaching a pbix which is originally from sqljason - I edited it to somehow work for your requirements.
https://drive.google.com/file/d/18WpSdQsNHJ5SX4C6I-5HQK4xWYcM8viW/view?usp=sharing
- ccjj
Here is my sample pbix
https://www.dropbox.com/s/z6zz5c7lab3j8wj/SampleScatter.pbix?dl=0
in the file, customers "A", "AA", and "AAA" are all overlapping and for some reason, I am unable to dynamically change the bubble size of the RED Selected customer. thank you!