Matrix Visual conditional column display under values section

Hi kgandhi2001 ,

Based on the information you have provided, Power BI does not currently support dynamically showing/hiding columns directly in Matrix visual objects based on drill-down operations. However, I can suggest a workaround to achieve similar results by utilising bookmarks and buttons. You can follow the steps below:

1. For each hierarchy level, create a separate Matrix visual object that displays only the columns associated with that level.
2. Use bookmarks to capture the status of the report page for each hierarchy level. For more information, see:
   Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn
3. Place buttons on the report that the user can click to navigate between the different hierarchy levels. Assign the appropriate bookmarks to the action attribute of each button. For more information see:
   Create buttons in Power BI reports - Power BI | Microsoft Learn

Although this method requires some setup and does not dynamically hide/show columns in a single Matrix visual object, it fits your requirements perfectly.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

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