topic Re: Dot plot graph in DAX Commands and Tips

Dot plot graph

Anonymous — Wed, 24 Aug 2022 07:26:29 GMT

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

Re: Dot plot graph

ValtteriN — Wed, 24 Aug 2022 08:27:59 GMT

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/

Re: Dot plot graph

Anonymous — Wed, 24 Aug 2022 09:11:32 GMT

It works! Thank you very much!