Could you post a packaged workbook (.twbx) with some sample data, and maybe even a mockup of the desired graph? What you describe isn't sufficient for me to identify where the problem is and what the solution might be.
Attached the "mockup" design in an Excel file.
As you'll see, Sales is the single measure varying throughout time, and "V" is calculated according to the formula mentioned.
Since the same "V" is based in the time-frame specified, it should be plotted as a horizontal line for the specific time (as a dual-axis, since it's a ratio) .
I am in the middle of the following:
- Duplicating the connection used for "Sales", with no blending or join (to prevent the "rolling effect" I have when using Window_Avg/StdevP)
- Using Parameters to catch Week_From and Week_To (to use them in a Dashboard for both connections)
- Calculating "V" on the secondary measure for the whole window, which is filtered to Week_From/To and hence should remain constant and accurate
Any comments or suggestions are more than Welcome. Thanks for helping out!
Volatility Mockup.xlsx 12.6 KB