Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
kgandhi2001
Frequent Visitor

Matrix Visual conditional column display under values section

Hello All -

 

My data set is something like this:-

 

kgandhi2001_0-1713413964216.png

 

 

My expected result is as below:-

 

As default

kgandhi2001_1-1713414191698.png

 

When we open 1 level of hirerchy EPIC => Feature (each Epic has multiple Features) and then each feature has multiple user stories.

kgandhi2001_2-1713414208699.png

 

Everytime we open one level Feature & User Stories Name columns are hidden/visual dynamically.

 

Any help would be appreciated?

 

Thank You

 

Regards,

gk03

2 REPLIES 2
v-yifanw-msft
Community Support
Community Support

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.

kgandhi2001
Frequent Visitor

Hello - Any help would be much appreciated.

 

Basically need to conditionally hidden or view the column based on the hirerachy closed or open.

 

If the Epic => Feature => User Story hirerachy is closed then only Epic Name column is displayed and Feature & User story names columns are hidden

 

If the 2 level of hirerachy is open Epic & Feature then we need to display Epic as well as Feature Names columns and User Stories Name column is hidden. likewise.

 

 

Any thoughts or suggestions?

 

Thank You

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.