How to Populate power bi parameter from other column

[shariq4powerbi]

Hi,

I have a column name wesbite which has values like amazon,target, walmart etc.

I want to create a parameter which should have the values available in website column.

Please help about how to populate parameter with values from other column.

[Mauro89 · Accepted solution]

Hi @shariq4powerbi,

Parameters in Fabric/Power BI don’t dynamically pull values from a column — they’re static lists you define up front. That’s why you won’t see column values auto-populating into a parameter.

Workarounds:

• If you want a filter based on column values, use a slicer in your report instead of a parameter. That way it always reflects what’s in the data.
• If you need to drive logic in Power Query with values from a column, create a list query (Reference → Remove other columns → Remove duplicates) from your website column, then use that list as the source for a parameter (note: it won’t refresh automatically unless you regenerate it).
• For more dynamic scenarios, consider creating a What If parameter or using a disconnected table of website values, which can be tied into DAX logic.

Here the link to docs which might help: Dynamic M Query Parameters in Power BI Desktop

If this helps you out, consider marking it as solution. 

Thanks and best regards!

[shariq4powerbi]

Hi @Mauro89,   thanks for the reply.

i actually want to break website column into 2 parts, first one will be mysite and other one competitor site.

So if in mysite column user select amazon then competitor site column should show rest values of website column except amazon .

any suggestioon.

[Mauro89]

Got it, thanks for clarifying. Parameters won’t give you that kind of dynamic behavior, but you can model it using DAX tables or Power Query.

Option 1 – DAX (recommended for reports):

1. Create a disconnected table with all website values (e.g. DISTINCT(YourTable[website])). Use that as a slicer for MySite.
2. For CompetitorSite, create a measure/table that filters out the selected value, for example:

CompetitorSites =
EXCEPT (
VALUES ( YourTable[website] ),
VALUES ( SelectedMySite[website] )
)

1. This way, once you pick “Amazon” in MySite, the CompetitorSite slicer only shows Target, Walmart, etc.

Option 2 – Power Query (static split):

If the logic is fixed (e.g. always Amazon = MySite, others = Competitor), you can split into two columns in Power Query. But if you want interactive “pick one, show the rest,” DAX is the flexible way.

Hope this helps as well. 
Best regards