how to hide other two columns in same table

[krishna_murthy]

Hi Team,

i have a requirement that is we have a table like below , Requesting please have look and provide us an update 

Employee	Department	Region	Email
A	HR	India	a@XYZ.com
B	HR	Switzerland	b@XYZ.com
C	Sales	Sweden	c@XYZ.com
D	Sales	Spain	D@XYZ.com

When we add slicer on the employee column 

once filter A then should come below table out of 4 column

Department	Region
Sales	India
Sales	Switzerland
HR	Sweden
HR	Spain

second once we filter C then should come below table out of 4 column

Region	Email
India	a@XYZ.com
Switzerland	b@XYZ.com
Sweden	c@XYZ.com
Spain	D@XYZ.com

[V-yubandi-msft]

Hi @krishna_murthy ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[V-yubandi-msft]

Hi @krishna_murthy ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

 

Thank you.

[V-yubandi-msft]

Hi @krishna_murthy ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[V-yubandi-msft · Accepted solution]

Hi @krishna_murthy ,

Thank you for sharing your requirement.

From your description, it seems you want to dynamically  hide specific columns in a table visual based on the selected Employee from a slicer. This is a common requirement, but currently, Power BI does not support dynamic column visibility based on slicer selections.

Power BI visuals, such as tables and matrices, do not support the conditional hiding or showing of columns based on slicer input. This feature is not available in the native visual customization options.

Related Documentation:

Slicers in Power BI - Power BI | Microsoft Learn

For more details, I’m sharing a related community discussion thread that closely matches your scenario. It’s worth checking out, as it offers helpful insights and potential solutions from other users facing a similar issue.

Dynamic Hideable Columns in Power BI Table Visual - Microsoft Fabric Community
 

To simulate dynamic views, you can use a combination of bookmarks, buttons, and layered table visuals. To achieve this, 

1. Create separate table visuals for each layout you want to display.
2. Use a disconnected Employee slicer to control which layout is shown.
3. Set up bookmarks that toggle the visibility of the visuals based on selection.

Helpful Microsoft Learn links

Create report bookmarks in Power BI - Power BI | Microsoft Learn
Create and configure buttons in Power BI reports - Power BI | Microsoft Learn

Please Accept as solution if this meets your needs and a Kudos would be appreciated.

Yugandhar.