How do I make the chosen name in a filter have a different shape in the scatter graph?

[Pablo_B]

Hi everyone,

I'm trying to do a peer group analysis showing a scatter graph of all the customers in that peer group. 

How do I make the chosen customer have a different shape than the others in the group?

Thank you in advance....

[AnthonyTilley]

This can be achived using the advanced scatter chart 

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380762?tab=Overview

add the chart from the market place.

allows you to specify a shape value there are 11 shapes avilable you can find a refrence here

https://dataveld.com/2016/02/17/microsoft-power-bi-enhanced-scatter-shape-reference/

in your example the Dot is the default with value 0 and the star is value 6 

to achive the result i create a second table with a list of the names 

Table = distinct(table[colunm])

this new table can be used as your slicer.

then create a measure that will asign the shape value to the selected value 

Measure = 
var sn = SELECTEDVALUE('Table 2'[NAME])
var n = MAX('Table'[NAME])

var ret = if(sn = n,6,0)
return ret

when you select the name value in the slicer the scatter chart shape will change as in the example below C is selected and is showing as a star while the rest remain Dots 

[Pablo_B]

Hi Anthony,

Thanks for getting back to me so quickly.  Is there any chance you could attach the example you created as I'm not getting the same results.  It's far easier to see what you did and work out my mistake.

Thanks again

[AnthonyTilley]

Apologise i did not save the work 

please show a screen grab of what issue you are having and i can explain the issue 

if i had to guess did you remember to make a new table with distinct values for your Dimension 

you cannot use the same filed in the Chart as you use in the slicer as this would just filter the data down to the individual value.

the Name filed in the chart will be from your orginal data source and the name filed in the slicer from a new table (the two shold not be joined) 

Regards,

Anthony

[Pablo_B]

I just figured out my mistake.  Thank you very much.  You're solution works, however, not as fully as I hoped.

I have many different customer names that are in different peer groups.

Is there a way to pick the name from the slicer that will change the scatter graph to the correct peer group as well as highlighting the chosen name with a star?

Please excuse me if these are silly questions, I'm a Tableau user that's starting to learn Power BI  :).

Thanks again.

[AnthonyTilley]

I would need to take a look at your lay out and data structure to achive what your looking for 

are you able to provide a sample PBIX file with your current model and data (can be redacted and use placeholders instead of actual data)

Regards

Anthony

[Pablo_B]

Hi Anthony,

Thank you so much for your patience and help.  Here's a link to a pbix file with dummy data.

https://www.dropbox.com/s/xw00krr5joc4qej/Peer%20Group%20Test.pbix?dl=0

Is there a way that when I pick the customer, the cohort group automatically gets picked as well?

Thanks again

[AnthonyTilley · Accepted solution]

Hi @Pablo_B 

i have made the adjustments you requested.

the chart will now filter to the choosen customers cohort insted of displaying all values.

PBIX File

[Pablo_B]

Thank you @AnthonyTilley 

That Solution worked perfectly.  You rock!!!

[Pablo_B]

Hi @AnthonyTilley ,

I've finally managed to open the file, but nothing is happening.  I click on a customer (using the name slicer), but it doesn't choose the cohort for that customer.  In fact I can't find anything different from the file I sent you.  Do you think you may have just attached the wrong file?

Thanks for your patience.....