Hello people!
I needed to replicate this histogram chart with normal distribution from excel to Power BI where for each market type (Spanish and Portuguese).
I calculate the "Minimum", "Maximum", "Averag"e value of the values of each agent and per week, in the "Size" counts the lines of each type of market, the Root of this size is calculated and the returned value we use to define the number of "Classe" dynamically, for the Increment we calculate (Maximum - Minimum)/Class, for the Standard Deviation we use the total column which is the average of the values of the selected weeks, o Increment 2 we calculate (Maximum - Minimum)/100 where this calculation will be used in the "Normal Distribution".
With the Class value defined we will define from 1 to the maximum integer value returned in the class calculation, the "Cut" and "Frequency" will be created based on this, for the Cut we will use the Minimum + Class * Increment calculation, for the frequency we define how many times each Cut is in the total of the average of the agents.
And with last calcs will create a histogram.
Tks for help!
https://1drv.ms/x/c/c959b830a59f4f8b/EeXAghV0AeVCvgZ4YMR8dTsBloDQ08eVWVOf1QmLW17f-Q?e=QDOayM
