Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
YYlee
Helper I
Helper I

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

 

YYlee_0-1716976938456.png

 

4 REPLIES 4
v-jingzhan-msft
Community Support
Community Support

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!

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 

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. 

vjingzhanmsft_0-1717395609739.png

 

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

Dear Jing, 

 

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

 

Thanks again!

 

Regards, 

YY

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.