Dax calculation to show all values and some values over box plot.

[Anonymous]

 Data as Below :

Machine/Non Machine	Serial No	Amount
Machine	abc123	200
Non Machine	xyz234	300
Non Machine	abc123	400
Non Machine	xyz234	100
Non Machine	wer345	50
Machine	weq23	250
Machine	abc123	150
Machine	xyz234	350
Machine	wdf456	450

Chart as Below

Requirement : 

In above chart we have Machine and Non Machine, Insted of Machine i want " All Machines" - Which is including (Machine + Non Machine) and NON Machine will remain same as it is.

I tried this in number of ways but that didn't work for me. Please Advice.

Regards

MR

[Greg_Deckler]

Which box plot visual are you using? 

[Anonymous]

box and Whisker Chart from Market Place

Screen Shot : 

Regards

MR

[Greg_Deckler]

OK, for some reason the Marketplace was giving me fits yesterday. I think you will need to do this in 2 box plot visuals. First, add a calculated column that is just:

Column = "All Machines"

Create your first visual using this column as your Category.

In your other visual, set it up the exact same way as you have now except filter out "Machine".

[Greg_Deckler]

Which box plot visual are you using?