Adding Parameter to filter in Power BI

[Kalaivani]

Hi All,

I am new to Power BI. Can any one let me know how to show all values in the paramter in a filter in Power BI? I added a list parameter with 3 values and set the current value to Clinic. But when I add the paramter to Filter, the list is showing just the clinic but not the other 2 values that I added to select dynamically. How to achieve this in Power BI desktop? Thanks in advance for your help!

@PBserver @PowerBl @PowerBI 

[Kalaivani]

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!!

[Anonymous]

Hi @Kalaivani ,

pbit can not upload.

and my sample data is like this:

You choose parameter AAA , and the desktop will display the value of AAA

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Kalaivani ,

In Power Query, create a parameter with the list of distinct values (e.g., Country names).Set the current value to the desired default (e.g., “Clinic”).

Apply Parameterized filter to Table 1 table, so data load only for selected country. To achieve this click on dropdown icon on country column in Table 1, Go to Text filter – Equals – change filter type from Text to parameter. select the parameter we just created – click OK and then close and apply and let the model get updated.

Last thing we need to do is to make the filter selection pop out when user run the report, in order to achieve this, save the file as a power bi template file (Pbit format).Now open the report and you will get the pop up to select the country once you select the country, data load only for selected country and you will see visual related to selected country

Below is the link will help you:

Dynamic Filtering Using Parameters in Power BI / Blogs / Perficient

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kalaivani]

Hi @Anonymous Thanks so much for the reply. Can you share the sample workbook that you showed in the snip with me? Thanks again!