Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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"
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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
15 | |
14 | |
13 | |
12 | |
11 |