Forum Discussion
Creating dynamic Power BI Parameters for Week on Week comparisons
Anonymous , For Week and WOW , refer to My blog, See if that can help.
If not
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi amitchandak , appreciate the support.
Attaching the sample Input & desired Output in an Excel. Also, sharing a pbix showing what I am able to achieve (against the desired output in Excel). https://acxiomconsulting-my.sharepoint.com/:f:/r/personal/siddharth_chowdhury_acxiomconsulting_com/Documents/Sample%20Q?csf=1&web=1&e=oMBRDc
Anonymous , No access to file. Please share it again. Also can you let us know the issue you facing in approch
Hi,
please try the above link.
The issue is that I want to allow my end user on Power BI service to input values for 'Expected Sales Factor'. Basis this factor, we calculate the 'Cover'.
For this purpose, I took the Parameter approach. However, this factor needs to be different every week (I might expect my sales to double in the current week, opposed to more than double in the next week).
As long as I am looking at one week only at a time, I am good to go - I can set the parameter to what I wish and see what is my Cover for that week. However, if I want to make a week on week comparison (say, show the Cover on a line graph with weeks on the axis), this falls apart. Since I can't input different values in the parameter when looking at more than one week at the same time.