The scatter plot is showing all influences. Now select “Values in reverse order” option. Just select the Y (vertical) axis and go to axis format settings (CTRL+1 shortcut). (2) Reverse the chart by changing Y (vertical) axis order Select columns 3 & 4 as shown in Picture A and insert scatter plot. (1) Make a scatter plot from “more by” and “influence order” columns
The Key Influencer chart demo’d at the start is actually a scatter plot. Now that everything is ready, go to Insert ribbon and add Key Influencer chart. (Picture A) Summary of all the calculations so far… Calculation Summary – Picture A Step 3: Start making the chart then… We can use simple arithmetic for 1 and RANK.AVG() for 2. Order (rank) of influence = Individual influence’s rank in all influences.Influence = average of criteria / average of not criteria – 1.Now that we have both averages, we can calculate the influence of something like this: Read this page if your INDEX() finger is weak. This is a powerful and elegant use of INDEX formula. So what does it do? This formula calculates average of data where M5 (Accounting for ex.) is found in the column that has the same header as L5 (Dept). =AVERAGEIFS(data,INDEX(data,MATCH(L5,data,0)),M5) Instead of writing formulas with manual criteria, we can tweak the column (data for ex.) on the fly. =AVERAGEIFS(data, data, "Accounting")įor all departments except "Accounting" Let’s be smart then., This is easily done by a couple of AVERAGEIFS formulas.įor example, =AVERAGEIFS(data, data, "Accounting")įor "Accounting" average pay.
Let’s look at top influencer for rating to be LOW: If role of the rating person is “Consumer” then their rating is 2.57 times likely to be low than other roles.
Now you want to know which aspects of your data impact the ratings most? You can create the key influencer visual and Power BI finds all the top ranking influencers (using rules and machine learning). As the name suggests, this is a chart of key parameters that effect a measure or outcome.įor example, you have customer satisfaction rating as a measure. Recently, Microsoft Power BI introduced a very useful visualization, called key influencers visualization.
0 kommentar(er)
