Create a Parameter off of a Column Query

sduvall — Wed, 10 May 2023 20:05:50 GMT

I'm trying to create a parameter using a Query from the values in my dataset.

From all of the tutorials I've watched, creating a Parameter requires you to have static values (i.e. a series of %'s, dates, metrics, etc.), however I'd like to have my parameter values be based off of the values in a column of my data (these names will change every time I refresh the data). Is this possible to do?

For Example, I have a dataset with a column named "Baseline Scenario" with a series of scenario names listed below.

However, when I upload a new dataset, or refresh the data, these Scenario Names may change and will no longer match what is listed, there may be more, less, etc.

What I'd like to do is have the Parameter Table read from whatever is listed here so that every time I refresh the data, I can have a slicer automatically know the scenario names based off of what was included in the data.

Is this possible?

Re: Create a Parameter off of a Column Query

lbendlin — Thu, 11 May 2023 16:42:24 GMT

Could that parameter come from a sharepoint list?

topic Create a Parameter off of a Column Query in DAX Commands and Tips

Create a Parameter off of a Column Query

Re: Create a Parameter off of a Column Query