Multi-Variable Scatterplot with user input

[DJBAJG]

Need to make the above scatter plot in Power BI however the big catch is all of the values highlighted in red need to be user inputs (parameters I assume). Need all of the help! LOL 

[DJBAJG]

Wow! Thank you for taking the time to put all of this together. I may be able to take some of these concepts and modify them to make something work but as it is I does not meet the need at all. 

I'm curious about you comment about text fields on the y-axis. None of the data I need to display is text based. The y-axis should be the "line placement". It's used to put space between the bubbles and keep all of the a groups data on the same line. This number should be static.

[Anonymous]

Hi @DJBAJG ,

Sorry, so far, to my knowledge, this may not be achieveable.

You can submit an idea for it at Home (microsoft.com) and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Anonymous]

Hi @DJBAJG ,

Due to design, the scatter plot does not support placing text fields on the y-axis, so we place it on the x-axis and the y-axis is used to place the values. Therefore, this may be a little different from the expected effect chart you gave, but this is the best restoration that PBI Desktop can do.

(1) This is my test data.

(2) We can create parameters. Note that you have 24 values ​​to enter manually, so you need to create 24 parameters.

(3)Then you can create a measure value. You can use the SWITCH function to input parameters. Here is an example of line 12. Please add or modify the measure value as needed.

Measure = SWITCH(TRUE(),
MAX('Table'[Group])="Group 1" && MAX('Table'[_Group])="Actuarial Values" && MAX('Table'[Type])="MYSELECT",SELECTEDVALUE('Parameter1'[Parameter1]),
MAX('Table'[Group])="Group 1" && MAX('Table'[_Group])="Actuarial Values" && MAX('Table'[Type])="MYCORE",SELECTEDVALUE('Parameter2'[Parameter2]),
MAX('Table'[Group])="Group 1" && MAX('Table'[_Group])="Actuarial Values" && MAX('Table'[Type])="MYSAVINGS HSA",SELECTEDVALUE('Parameter3'[Parameter3]),
MAX('Table'[Group])="Group 1" && MAX('Table'[_Group])="Actuarial Values" && MAX('Table'[Type])="MYBASIC",SELECTEDVALUE('Parameter4'[Parameter4]),
MAX('Table'[Group])="Group 2" && MAX('Table'[_Group])="Actuarial Values" && MAX('Table'[Type])="MYSELECT",SELECTEDVALUE('Parameter5'[Parameter5]),
MAX('Table'[Group])="Group 2" && MAX('Table'[_Group])="Actuarial Values" && MAX('Table'[Type])="MYCORE",SELECTEDVALUE('Parameter6'[Parameter6]),
MAX('Table'[Group])="Group 2" && MAX('Table'[_Group])="Actuarial Values" && MAX('Table'[Type])="MYSAVINGS HSA",SELECTEDVALUE('Parameter7'[Parameter7]),
MAX('Table'[Group])="Group 2" && MAX('Table'[_Group])="Actuarial Values" && MAX('Table'[Type])="MYBASIC",SELECTEDVALUE('Parameter8'[Parameter8]),
MAX('Table'[Group])="Group 3" && MAX('Table'[_Group])="Actuarial Values" && MAX('Table'[Type])="EPO",SELECTEDVALUE('Parameter9'[Parameter9]),
MAX('Table'[Group])="Group 3" && MAX('Table'[_Group])="Actuarial Values" && MAX('Table'[Type])="PPO",SELECTEDVALUE('Parameter10'[Parameter10]),
MAX('Table'[Group])="Group 3" && MAX('Table'[_Group])="Actuarial Values" && MAX('Table'[Type])="HDHPw",SELECTEDVALUE('Parameter11'[Parameter11]),
MAX('Table'[Group])="Group 3" && MAX('Table'[_Group])="Actuarial Values" && MAX('Table'[Type])="HDHPw/o",SELECTEDVALUE('Parameter12'[Parameter12]),
SUM('Table'[Value]))

(4) Create a scatter plot and place the fields as shown below. Please note that because the maximum and minimum values ​​of the y-axis are very different, some bubbles will not be obvious. This is by design. You can adjust the maximum and minimum values ​​to see them, or use the slicer. In addition, you can also create a matrix to display the data more intuitively.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.