Need help with adding a new field parameter based on a specific category

[Kenzaobd99]

Hello Power BI community,

I'm facing an issue with adding a new field parameter to my existing list in Power BI Country.pbix . Currently, I have a fields parameter that I use in visuals and visual filters to filter data based on the file I choose. First here's my table :  

Here is a snippet of my existing parameter: 

and it's used like this in visuals with diff metrics  

Now, I want to add a new parameter based on the category column from the table, meaning that when I choose Country from the filter the table gives me names with category "Country". I tried the following by specifying the category name but it didn't work when I select it from the filter it doesn't exclude the other that aren't countries: 

Could someone please help me to achieve this? Any suggestions or guidance would be greatly appreciated. 

Thank you in advance! 

[samratpbi · Accepted solution]

Hi, I think what you can do is create a calculated column that will have Country categories only.

Country = CALCULATE(VALUES(F_Param[Category]), F_Param[Category] = "Country")

Then create a field parameter using all 3 columns.

field_param = {

    ("Name", NAMEOF('F_Param'[Name]), 0),

    ("Category", NAMEOF('F_Param'[Category]), 1),

    ("Country", NAMEOF('F_Param'[Country]), 2)

}

If this helps to resolve your problem then please mark it as solution, Thanks!

[ThxAlot · Accepted solution]

In MS official documentation, it reads as follows,

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

... if you want to add a new field to an existing parameter, ... and match the format shown in this example.

Parameter = {
    ("Customer", NAMEOF('Customer'[Customer]), 0),
    ("Category", NAMEOF('Product'[Category]), 1),
    ("Color", NAMEOF('Product'[Color]), 2),
    ("Product", NAMEOF('Product'[Product]), 3)
}

So, your expression might not be recognizable in a field parameter table. 

[samratpbi · Accepted solution]

Hi, I think what you can do is create a calculated column that will have Country categories only.

Country = CALCULATE(VALUES(F_Param[Category]), F_Param[Category] = "Country")

Then create a field parameter using all 3 columns.

field_param = {

    ("Name", NAMEOF('F_Param'[Name]), 0),

    ("Category", NAMEOF('F_Param'[Category]), 1),

    ("Country", NAMEOF('F_Param'[Country]), 2)

}

If this helps to resolve your problem then please mark it as solution, Thanks!