Can I group few of the column header become a choice in slicer and show the column in the table?

[dwlee898]

Hello everyone,

Do I have the way to group few of the column header become a choice in slicer and show the column in the visual such as table? For example, I have a dataset with few column such as Title, Account Client Status, Payroll Client Status, Audit Client Status and Audit Remarks. I want to seperate them to 2 groups such as

Account

• Title
• Account Client Status
• Payroll Client Status

Audit

• Title
• Audit Client Status
• Audit Remarks

The slicer I want to put 2 choices Account and Audit. Once I choose Account. The visual such as table will be like. Is this possible?

Title	Account Client Status	Payroll Client Status
Company A	ON	ON
Company B	ON	ON
Company C	ON	ON

[Anonymous · Accepted solution]

Hi @aduguid ,thanks for the quick reply, I'll add more.

Hi @dwlee898 ,

As @aduguid  said, the field parameter can meet your needs.

The Table data is shown below:

Please follow these steps:

1.Create two field parameters.

2.Modify the expression of the field parameter

Parameter = {
    ("Title", NAMEOF('Table'[Title]), 0,"Account"),
    ("Account Client Status", NAMEOF('Table'[Account Client Status]), 1,"Account"),
    ("Payroll Client Status", NAMEOF('Table'[Payroll Client Status]), 2,"Account")
}

Parameter 2 = {
    ("Title", NAMEOF('Table'[Title]), 0,"Audit"),
    ("Audit Client Status", NAMEOF('Table'[Audit Client Status]), 1,"Audit"),
    ("Audit Remarks", NAMEOF('Table'[Audit Remarks]), 2,"Audit")
}

3.Manually enter the following data to create a table and establish a relationship

Final output

Best Regards,
Wenbin Zhou

[aduguid]

Yes, it's possible to achieve this in Power BI using Field Parameters. Field Parameters allow you to dynamically control which fields are displayed in a visual based on a slicer selection.

Here's how you can set it up:

Steps to Create Field Parameters:

1. Create Field Parameters:

   • In Power BI Desktop, go to the "Modeling" tab.
   • Select "New Parameter" and then choose "Fields."
   • Name the parameter (e.g., "Group Selector").
   • Add the relevant fields for each group. For example:
     • Account Group: Title, Account Client Status, Payroll Client Status
     • Audit Group: Title, Audit Client Status, Audit Remarks
   • Click "OK" to create the parameter.

2. Modify the Field Parameter:

   • In the Fields pane, you’ll see a new table created with the Field Parameter. Open it, and you’ll find the fields added during creation.
   • The parameter table will also have a column for the group selection options (e.g., Account, Audit).

3. Add the Field Parameter to a Visual:

   • Create a table visual and add the Field Parameter (e.g., "Group Selector") to the "Columns" field well.
   • Power BI will automatically adjust the columns based on the slicer selection.

4. Create a Slicer for the Groups:

   • Add a slicer visual to the report.
   • Drag the Field Parameter table into the slicer.
   • When you select "Account" or "Audit" in the slicer, the table visual will adjust to show the corresponding columns.