Trendlines on clustered column chart
Is there a way to add a trendline on this type of chart? I cant seem to find it anywhere. I would like to see the trendline move with whichever product line is selected. For instance, if we are looking at bath lights, we would see the trendline based on the Avg Qty Sold . Example below along with the Visualization pane. Thank you!!
LINEAR REGRESSION - X-AXIS IN TEXT FORMAT
Hello I am working with a data sample that contains numeric values on "y" axis (pH results) and text values on "x" axis (sample/batch code) and need to build a linear regression analysis. So far, I found a website "IterationInsights" that published an article "How to do simple linear regression in Power BI", which really helped me to analyse using date, but not sample code (since it is a text). I need to evaluate the trend between 2 samples, independent of when they were collected. Note that if x is a Date, we have: y = 0.0023x - 99.065, r² = 0.2566 But if x is the sample, we have: y = 0.0297x + 5.5252, r² = 0.3024 How am I able to build a variable table that converts the sample code to a numeric sequence (A1AA/22 = 1, A2AA/22 = 2, ...., A21AA/22 = 21)? Besides, it's possible to filter this table? Ex: analyse A12AA/22 to A20AA/22 (interval which would automatically be converted to the numbers: A12AA/22 = 1, A13AA/22 = 2, ...., A20AA/22 = 9, always starting with 1). Since slope formula is: [n(Σxy) - (Σx)(Σy)] / [n(Σx²) - (Σx)²], x should be refeered as a sequence of natural numbers representing the samples. n is the distinct count of the samples. I suppose that I should build a data var table to convert sample code to a number, and use All selected function to filter the samples I'm working with, but I'm really having a hard time to combine these functions and obtain a functional linear regression equation. I exemplified the solpe formula because I think the same solution would be applied to intercep, r², etc. For slope, I used the formula: --------------------------------------------------- SLOPE = var data = SELECTCOLUMNS(ALLSELECTED(DATA), "x_values",DATA[DATE], "y_values",DATA[RESULTS] ) --Variables to Solve for: var y_sum = SUMX(data,[y_values]) var x_sum = SUMX(data,[x_values]) var x2 = SUMX(data,[x_values]^2) var xy = SUMX(data,[x_values]*[y_values]) var row_count = COUNTROWS(data) --Solve for formula var Slope = ((row_count * xy) - (x_sum * y_sum))/((row_count*x2)-((x_sum)^2)) return Slope ----------------------------------------------------- Anyone could help me?
How to calculate a running total of Vulnerabilities?
Hello, For the life of me I cannot figure out how to create a running total trend line of vulnerabilities from my organizations Fortify SAST tool. Below is an example of the data that I am currently exporting into Excel. What I am trying to do is show a running total of vulnerabilities by Severity at an enterprise level for all applications, and then at an individual application level. I would also create trend lines for OWASP status, Developer Status, etc. Example Data Vuln ID Severity Status Developer Status Introduced Date OWASP ApplicationID ReleaseID Category 1 Critical Fix Validated Will Not Fix 1/2/2018 A1 12345 21212 Injection 2 Critical New Will Not Fix 2/6/2019 A2 12345 21212 Session Mgmt 3 Critical Existing Open 2/12/2019 A2 32165 321321 Session Mgmt 4 Critical Existing Open 5/8/2020 A3 32165 654654 Privacy Violation 5 High New Open 12/1/2020 A9 11111 654654 3rd party 6 Medium Re-Opened In Progress 1/16/2021 A9 11111 212121 3rd party 7 Low Existing In Progress 2/3/2021 A1 12345 321321 Injection I have been able to create the trend line data I am looking for with Excel formulas by running a count of every status every week. Here is an example of the data and trend that I am trying to reproduce in Power BI Any help on this would be greatly appreciated. Thank you, Eric
