Forum Discussion
Parameter and Navigation Step
Hi all, I need to create a Parameter just to replace the Feb 22 portion of the below statement. Or if that cannot be done then the AR Feb 22 portion below. Want to do this so the user can just upda...
Well it is fairly simple. I am bringing in an Excel Workbook with a Sheet Name of AR Jan 22. Next month our Finance department will create a new worksheet called AR Feb 22. And this continues throughout the year. Right now I go into the data model in PowerQuery and change the "Item" as noted above from AR Jan 22 to AR Feb 22, save, publish and refresh. Basically I want to know if the "Item" can be a parameter entered in on the PowerBI service by our Finance group. So they can change the Sheet name whenever they are ready. Something like
Item = (Parameter), Kind = Sheet...........
Just want to know the syntax for this parameter.