Show relationship between 2-4 variables in Power BI

[YYlee]

Hi all, I am looking for help in Power BI.

I have some variables as below and some criteria need to fulfill. I have try scatter chart but only apply to 2 variables, and I am not sure why my power bi could not find the correlation visualisation. 

A-H values from 0-100

AA-DD values will be 1-3

I wish to show that

A+C+D+H have impact on AA 

B+C+H have impact on BB

But A-H do not mean higher then is better, "E" may be lower then is better, "F" range might be between 25-75 is the best

AA+BB will affect on "Potential"

[Anonymous]

Hi @YYlee 

As the value ranges are different, maybe you can use two scatter charts to display them separately. At present I cannot think of a visual which can meet your need. As an alternative, you can use several different visuals to work together to display the data.

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[YYlee]

Dear Jing, 

Thank you for your advice. 

So may I confirm for Power BI there is 2 variables to presents at most?

What do you advice for other different visual that is good for present?

Thanks. 

Regards, 

YY 

[Anonymous]

Hi @YYlee 

It depends. Sometimes we can use a Combo Chart. For example with visuals as below, we can have a common x-axis, then have two y-axes: line y-axis & column y-axis, or y-axis & secondary y-axis. We can also add field to Legend or Small multiples. This can help us analyze data between more than 2 variables. 

Sometimes we can use the Bubble chart (Scatter chart). The bubble chart is essential for visualizing the 3- or 4-dimensional data on the plane. The x-axis corresponds to an independent variable, the y-axis – to a dependent. The third and fourth variables can be represented by the size of a data point and its color (Legend). Scatter, bubble, and dot plot charts in Power BI

Best Regards,
Jing

[YYlee]

Dear Jing, 

Thank you for your advice. I will consider about all of your options. 

Thanks again!

Regards, 

YY