Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Creating a scatterpolt that updates based on a "dynamically" populated table

Hi everyone,

 

I am trying to make a scatterplot that updates dynmically based on a filter selection and uses data points pulled from two columns. Here's a small dataset similar to what I'm working with.

 

ClientIndustryIndex AIndex B
Bubble MasterSoap32
Sud KingSoap45
Soapy MessSoap23
Clean WashSoap32
Meaty KibbleDog Food11
Dog's DelightDog Food11
Tasty TreatDog Food11
Woof DinnerDog Food11

 

I would like to create a scatterplot that maps Index A on the X-axis and Index B on the Y-axis, has a data point for a single client (based on a filter selection), a data point for the Industry associated with the Client (mapped on the averages of Index A and Index B), and an "Overall" data point for the average Index A and Index B for the entire dataset. Here's a very barebones example of the scatterplot, with the Sud King selected as the Client.

 

If a different Client were selected, I'd like the data points to change (e.g., if Tasty Treat were selected, then both the Client and the Industry data points would move). I've tried making this work by contructing a table that pulls from the dataset, but Power BI cannot make dynamically updating tables. 

 

Does anyone have a suggestion re. what to do? Thanks for any help.

 

Cheers,

 

T

 

Update: Please note, for the data points in the example scatterplot, the size of the bubbles/dots is not relevant. The bubbles are simply illustrative and could be replaced with equal-sized dots. Also, the coordinates for the Industry and Overall data points are calculated using the mean values of Index A and Index B. (Thanks for the suggested updates, lbendlin.)

1 Reply

  • Great question, similar to "Top 5 and Others"  Showing the top 5 products and Other row - SQLBI

     

    However, there are a lot of caveats here.  Firstly, your data is missing the weight column (the bubble size).  And then - what is your strategy for calculating "Soap"  - as an average? as a Least Squares interpolation? Some other grouping algorithm?