Compare 1 Customer Against the Rest

[kleetus51]

I'm not sure if I'm choosing the right visual or not, but I have a use case that I'm trying to represent. I'd like to show where 1 customer stacks up to all other customers in terms of how quickly they pay their bills. The Maq Software Box and Whisker visual is the closest I've found, but doesn't get me all the way there. This is a customer facing visual, so I don't want to show where other customers sit on the box, just a dot for the customer I'm showing this to. 

For example:

With all customers selected in the filter, I get green dots for ALL customers:

When I select a customer in the filter, the boxes disappear, but I do get the 1 dot representing the selected customer:

What's I'd like to have is the first example, but with only 1 green dot representing the selected customer. Is this possible using Box and Whisker or is there another visual that would get me similar results? Data example below:

Customer	Avg Days to Pay
BEV	168
EPE	164
THG	88
QQD	147
NSA	65
RTV	40
FSR	35
JZO	136
JCK	164
WEK	24
DVN	121
TXW	59
GLR	131
HAO	29
HHD	114
EMJ	116
XBE	65
RVT	124
RKK	159
BGC	92
VUV	42
DFI	10
ECQ	27
QAJ	113
NGC	132
HJA	66
LNJ	38
QTE	105
CJR	149
BUR	113
GSN	45
QFY	50
PBZ	30
WVL	20
XBE	20
ECB	15
PTI	130
JAG	159
SFZ	116
OVA	17
PJQ	65
GRD	52
NJP	95
GLH	38
VLC	74
YFP	66
ARW	86
LTT	107
OPD	72
HPS	98
UFP	107
QDF	80
UBK	59
PIK	151
TDE	48
XSG	116
NOQ	18
DTQ	81
QNG	101

[V-lianl-msft · Accepted solution]

Unfortunately, as far as I know, Maq Software Box and Whisker does not support conditional formatting. Maybe you can try to overlay two images, set the interaction between one of them and the slicer to none, set the transparency of the upper visual to 100%, and display the dot in different colors.

[kleetus51]

Thanks, that's what I ended up doing. It does what I need it to, but is a bit of a workaround. 

[lbendlin]

"This is a customer facing visual, so I don't want to show where other customers sit on the box, just a dot for the customer I'm showing this to"

This goes into the danger zone very quickly, you are risking data leakage.  The visual type is the least of your problems here.  You need to create measures that compute the desired results, and you will most likely also want to implement RLS and hidded reference tables.

Please explain how you are planning to prevent customers from seeing each others' data.

[kleetus51]

Data security is a secondary concern for my purposes. These are all customers that have opted into comparative market studies based on the data I'll be using.