cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
StephShadwell Frequent Visitor
Frequent Visitor

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 on right, showing all points within parent selection 

Scatter Chart.PNG

However, i want to have only 2 groups for the scatter graph on the right, so i have just 2 colours

1) Area Selection Name

2) Rest of areas within parent name 

 

I have tried to create a new table, that ultimately has all area names plus 'Other', thinking i could then write a DAX measure with 3 variables (Selected Area, Unselected Area, All Areas), and then return the values accordingly, but this doesn't seem to work. Has anyone done something similar or have any suggestions?

2 REPLIES 2
Community Support Team
Community Support Team

Re: Dynamic Grouping on Scatter Chart based on slicer selection

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
StephShadwell Frequent Visitor
Frequent Visitor

Re: Dynamic Grouping on Scatter Chart based on slicer selection

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

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 242 members 2,654 guests
Please welcome our newest community members: