Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Expand and collapse feature on Matrix Visual

Hi Gurus

I have a requirement with respective to the expand and collapse feature let me expalin the scenaio briefly. below is the databse structure. i am using as matrix table to full fill the requirement but it is not showing the results as expected. below is the scenario to understand the data.

 

While expanding with the + icon below is the expection.

While collapsing with - icon below is the expectation.

Note : While collapsing the parent data should be visible and while expanding child information data should visible. How can we achieve this in a matrix visual. Could you please some one help me in this scenario.

 

I really appreciate thank \you so much in advance.

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,
    Here some steps that I want to share, you can check them if they suitable for your requirement.
    Here is my test data:

    Create a measure

    Name = 
IF(
    ISFILTERED('Table'[Employee ID]),
    SELECTEDVALUE('Table'[Employee Name]),
    IF(
        ISFILTERED('Table'[Manager ID]),
        SELECTEDVALUE('Table'[Manager Name])
    )
)

    Final output




    Best regards,
    Albert He

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

     

     

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous 

     

    If you are facing this issue than for once check the value of order plotted in the value. This is an issuse related to the order of column of manager name and employee name.

     

    Best Regards.

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi, Thanks for the help


      Could you please help me some dummy data so that accordingly I will give order to my data model.

       

      Thanks 

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Anonymous 

         

        Can you just send me snapshot of the visual bar that how you have plotted row, column and value in the matrix accordingly, I'll be able to help you easily.

        Best Regards.

        If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
        If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,

    As per your suggestion I have provided some dummy data along with my requirement but after that I did not receive any reply from your side. Could you please check any approched that could be really appreciated.

    Thanks,

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,
    Here some steps that I want to share, you can check them if they suitable for your requirement.
    Here is my test data:

    Create a measure

    Name = 
IF(
    ISFILTERED('Table'[Employee ID]),
    SELECTEDVALUE('Table'[Employee Name]),
    IF(
        ISFILTERED('Table'[Manager ID]),
        SELECTEDVALUE('Table'[Manager Name])
    )
)

    Final output




    Best regards,
    Albert He

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