Forum Discussion

Icon for Helper I rank

Helper I

2 years ago

Show relationship between 2-4 variables in Power BI

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 ...

Anonymous

Not applicable

2 years ago

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
Helper I
2 years ago
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
  Not applicable
  2 years ago
  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
    Helper I
    2 years ago
    Dear Jing,
    
    Thank you for your advice. I will consider about all of your options.
    
    Thanks again!
    
    Regards,
    YY