Forum Discussion

StephShadwell's avatar
StephShadwell
Frequent Visitor
8 years ago

Dynamic Grouping on Scatter Chart based on slicer selection

I am the process of creating a report in power bi. I have 2 scatter charts on the page. (see screenshot below) 1) Scatter chart on left, showing just points in final area selection 2) Scatter chart...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi StephShadwell，

 

I 'm not clear about your data structure, so I cannot reproduce your scenario. 

 

If it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

Best Regards,

Cherry

StephShadwell's avatar
StephShadwell
Frequent Visitor
8 years ago

Apologies for the delay, please see link to file (https://1drv.ms/u/s!AsoxVmjjxqm_iBO3sIVbZTD605jc )

 

It is a fairly straight forward data model, with the area boundaries ultimately driving the mapping, with the main data being taken from the health inequalties sheet, with the STP data ultimately being appended to the bottom of the health inequalities to make one data table.

 

The 2 scatter charts are on the premature mortality tab, with the one on the left showing purely the area selected, and the one on the right showing the selection and all other data from the parent. What i am looking to achieve is the area selected to show in 1 colour and the other areas to be grouped, bearing in mind the selection could always potentially be different, so would need to be dynamically working out the groupings based on the selections.

 

Thanks