Forum Discussion

Goatuser147's avatar
Goatuser147
New Member
1 year ago

Expand/Collapse a Matrix by a specific Propertylevel

Hello,

I have the following table and would like to be able to expand the matrix/table based on a specific value (Level):

RegionLevelFeature 1Feature 2
Europe1af
Germany2bg
France2ch
North America1di
Canda2ej


Goal (if the User clicks on "+" it should expand towards the second level) - (feature values should not be aggregated to a higher level):

Region Feature 1Feature 2
Europe (+) af
 Germanybg
 Francech
North America (+) di
 Candaej


Is this currently possible in PowerBI and if so could you point me towards the right direction?

Thanks in advance

Need Help

3 Replies

  • uzuntasgokberk's avatar
    uzuntasgokberk
    Super User
    1 year ago

    Hello Goatuser147,

    Yes, it is posibble to use matrix in Power BI. Here is the example:

     
    But in values, there is a some rule that you need to follow, such as first, last etc.

    Kind Regards,
    Gökberk Uzuntaş

    📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

    🔗 Stay Connected:
    📘 Medium |
    📺 YouTube |
    💼 LinkedIn |
    📷 Instagram |
    🐦 X |
    👽 Reddit |
    🌐 Website |
    🎵 TikTok |

     



    • Goatuser147's avatar
      Goatuser147
      New Member
      1 year ago

      Hello Uzuntaş,

      thank you for your proposed solution.

      The difficulty i have is that all Regiondata are stored in the same column. In your case you have two different columns, one for "racename" and one for "team". In my case both information are stored in the same column. Only the supplementary colum "level" gives the information in which level the propertyvalue belongs.

      Unfortunatly this way your proposed solution does not work. Do you have any idea how to make it work for this case?

      Thanks in advance and best regards

      • uzuntasgokberk's avatar
        uzuntasgokberk
        Super User
        1 year ago

        Hello Goatuser147,

        İf the data includes only one column, you need to split or seperate it somehow. Otherwise, you couldn't +/- icons. To observe your column, you might have "Adam-5798" and you can use split "-" in Power Query. İf it is based on lenght you can use custom add column in power query. İf you give me dummy data. I can help you with that. 

        Kind Regards,
        Gökberk Uzuntaş

        📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

        🔗 Stay Connected:
        📘 Medium |
        📺 YouTube |
        💼 LinkedIn |
        📷 Instagram |
        🐦 X |
        👽 Reddit |
        🌐 Website |
        🎵 TikTok |