Forum Discussion
Dax calculation to show all values and some values over box plot.
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
4 Replies
- Greg_Deckler
Community Champion
Which box plot visual are you using?
- Greg_Deckler
Which box plot visual are you using?
- 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".
