Forum Discussion
Helper IIhow to hide other two columns in same table
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 | |
A | HR | India | |
B | HR | Switzerland | |
C | Sales | Sweden | |
D | Sales | Spain |
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 | |
India | |
Switzerland | |
Sweden | |
Spain |
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,
- Create separate table visuals for each layout you want to display.
- Use a disconnected Employee slicer to control which layout is shown.
- 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 LearnPlease Accept as solution if this meets your needs and a Kudos would be appreciated.
Yugandhar.
4 Replies
V-yubandi-msftCommunity Support
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,
- Create separate table visuals for each layout you want to display.
- Use a disconnected Employee slicer to control which layout is shown.
- 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 LearnPlease Accept as solution if this meets your needs and a Kudos would be appreciated.
Yugandhar.
- 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
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 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.