cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Creating parameter/template using column

Hi folks, 

 

Need help with something I'm working on. Trying to create a PBIT file, with a simple dataset, it has one table and 6 columns. I want it so that when user opens up the PBIT file they have to choose their TeamName via a drop down (there are a number of teams in the dataset), which I'd like to be populated using the TeamName column in the DB. Source is an Azure SQL DB (s/shots below of dataset):

 

Screenshot (97).png

 

Any thoughts?

1 ACCEPTED SOLUTION
JontyB
Frequent Visitor

@Anonymous i havent used this in any of my reports... yet, however from my understanding of your question you need to have a parameter set up and a list of your teams. create a duplicate of your official data and remove all other columns apart from your teamname column. once you have just this column you need to convert it to a list (transform -> any column -> convert to list) you then click manage parameters -> new parameter and create a parameter, give it a name, type is "text" suggested values = "query" then select your list from the Query dropdown. you will have to add a default value, once that is done go back to your original table (official data) and selet the filter option on the column you want to filter by, i think it is TeamName in your screenshot. and in the filter select text filter and equals, then the dropdown to the left of the "enter or select value" dropdown select parameter and select your parameter name from the drop down, save this as a pbit file and when you open it it will prompt you to select a team name. finger crossed ive been able to explain this simply. any questions just let me know  

 

View solution in original post

2 REPLIES 2
JontyB
Frequent Visitor

@Anonymous i havent used this in any of my reports... yet, however from my understanding of your question you need to have a parameter set up and a list of your teams. create a duplicate of your official data and remove all other columns apart from your teamname column. once you have just this column you need to convert it to a list (transform -> any column -> convert to list) you then click manage parameters -> new parameter and create a parameter, give it a name, type is "text" suggested values = "query" then select your list from the Query dropdown. you will have to add a default value, once that is done go back to your original table (official data) and selet the filter option on the column you want to filter by, i think it is TeamName in your screenshot. and in the filter select text filter and equals, then the dropdown to the left of the "enter or select value" dropdown select parameter and select your parameter name from the drop down, save this as a pbit file and when you open it it will prompt you to select a team name. finger crossed ive been able to explain this simply. any questions just let me know  

 

Anonymous
Not applicable

Perfect thank you 🙂

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors