Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

JimmyCruyp

Correlation Plot in Deneb

Submitted by Helper II on ‎02-23-2023 10:42 AM

Does anyone know where I can find the code to create the correlation graph which was on the store in R and which is no longer there? In Vega or Vega lite for Deneb? Thank  you so much. 

a38b34b5-4464-4c9e-9e1c-90f8fa64d77f.png

 

Status: Investigating
See more ideas labeled with:
13 Comments (13 New)
Comments
giammariam
Solution Sage
Solution Sage
‎03-07-2023 02:01 PM

Hey @JimmyCruyp. Honestly I'm not quite sure how you would set up the correlation matrix with the currency data that you provided since each currency is compared to the usd. This is likely why I was having issues initially. From what I understand about creating a proper correlation matrix, you need multiple observations (rows) over two or more variables that each have quantitative values. You then compare all the possible combinations of the quantitative values for these variables against one another - this is what the measures are doing.

  • n = number of observations
  • x = the sum of values for a given variable. These variables go across the top and you could think of these values as the totals for each column of the matrix
  • y = the sum of values for a given variable. These variables go vertically on the left side and you could think of these values as the totals for each row of the matrix
  • X^2 = the sum of each X value squared for a given variable
  • Y^2 = the sum of each Y value squared for a given variable
  • XY = the sum of (each X value) x (each Y value) for a given variable
  • Correlation Coefficient = ((n*XY) - X*Y) / ((n*X^2 - (X)^2) *(n*Y^2 - (Y)^2))

 

  

giammariam_0-1678221564458.png

 

These helped me:

JimmyCruyp
Helper II
Helper II
‎04-05-2023 01:16 AM

@giammariam Hello super hero. I have a general question about this kind of super development you created for me. Can you put it on the Power BI graph store? I don't want to do it myself because I assume you have the rights and intellectual property on it? I would like it to be on the store, so that we can benefit from the native features of Power BI: for example, users can read-only on the online service change the data, change the design, use or not this graph or an other. what do you think? How do you give access to this graph to the whole world? If not, can I do it myself in the worst case? but it's still you who created it even if I asked you the question... it is also very important in terms of reliability and risk. Will it make reliable, harden the graph and the versions of the graph over time since maintained by Microsoft?

giammariam
Solution Sage
Solution Sage
‎04-05-2023 07:44 AM

Hey Jim. The charts in AppSource are Power BI Custom Visuals which are built in Typescript often with libraries such as d3.js and react. The nice thing about this solution is that it only relies on the core matrix visual that comes with Power BI. The downside is that there are a lot of workarounds in place to get it to work. 

The level of effort required for creating a certified Power BI Custom Visual is very significant. I can see the benefit of being able to configure this correlation matrix just like any core visual (i.e. formatting pane options), but the work necessary to make that happen goes well beyond the scope of the type of free assistance that one can expect to be provided in this community. 

 

However, since you have this raised under the ideas section of this community, if you can get enough people to vote for it, maybe Microsoft will incorporate some of the techniques used here in either their core matrix visual, or a new visual. 

Idea Statuses