Dot plot graph

[Anonymous]

Hi 🙂

do you have any idea how can I change the size of the dots in my dot plot graph (see photo). For example I want that L is the bigest one, and UNDER ASSESSMENT the smallest one. S und M are between then. Do I need a new measure? Is there any DAX Commands? 

Best regards

 

[ValtteriN · Accepted solution]

Hi,

The size is dictated by values in the "size" area:

I recommend creating a new measure that has conditions so that the sizes correspont the ones you want.

E.g. with SWITCH. Something like this:
var _class = max(table[class]) return
SWITCH(TRUE(),
_class = "L",4,
_class = "M",3,
_class = "S",2,
_class "UNDER ASSESMENT",1)


I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[Anonymous]

It works! Thank you very much!