Adding Parameter to filter in Power BI

Helper III

2 years ago

Hi Anonymous Actually my requirement is like this - I have a parameter called CompareBy with 3 values- Clinic, Specialty and Provider. I want to add that CompareBy to a filter. And then I have another table called Provider Attributes in which I have Office_Name, Expertise and ProviderName columns. So when I select Clinic from CompareBy, I need a column that lists all Office_Name values from the Office_Name column. And when specialty is selected all values of expertise should show. And when provider selected, all values of providername should show. I need to add the column that is listing all these values corresponding to CompareBy filter to an another filter. So the newly created column has to list the values correspondingly based on the CompareBy value that I selected.

I have a column called CompareGroup created here with the below code.

CompareGroup =

SWITCH (

SELECTEDVALUE('Parameter1'[Parameter1]),

"Clinic", 'Provider Attributes'[Office_Name],

"Subspecialty", 'Provider Attributes'[Expertise],

"Provider", 'Provider Attributes'[ProviderName]

)

Now when I select Clinic, corresponding Office_Names are showing up in the CompareGroup.

The only issue am facing is, I am able to change the parameter values only through edit parameter option. But when I add that parameter to the filter, it is just showing clinic in the dropdown. I need all 3 in the drop down so that users will be able to select any one of those 3. Thanks so much!!

Forum Discussion

Related content

Adding filters to a calculated column

Parameter in summarize

Using parameters to filter to desired number of rows

Filter Field Parameter by Field Parameter Values without Calculated Groups

Adding columns