Forum Discussion
Creating dynamic Power BI Parameters for Week on Week comparisons
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.
Hi Anonymous ,
If you want multiple parameters for each week, you could save them in a table and match them when you are ready to calculate the "Cover".
Or you could create multiple independent slicers to select parameters with SELECTEDVALUE() function.
You could also vote for this idea to improve Power BI and make this feature coming sooner.
