Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All -
My data set is something like this:-
My expected result is as below:-
As default
When we open 1 level of hirerchy EPIC => Feature (each Epic has multiple Features) and then each feature has multiple user stories.
Everytime we open one level Feature & User Stories Name columns are hidden/visual dynamically.
Any help would be appreciated?
Thank You
Regards,
gk03
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:
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.
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