Expand/Collapse a Matrix by a specific Propertylevel

[Goatuser147]

Hello,

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

Region	Level	Feature 1	Feature 2
Europe	1	a	f
Germany	2	b	g
France	2	c	h
North America	1	d	i
Canda	2	e	j

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 1	Feature 2
Europe (+)		a	f
	Germany	b	g
	France	c	h
North America (+)		d	i
	Canda	e	j

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

Thanks in advance

[uzuntasgokberk]

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]

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]

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 |