How to expand a field with a "+" button

[Quenjo]

Hi community,

Let's take an example :

I have a table named "company" related to a table named "applications" related like this :

Right now, the relation is working and I have a list like :

Company 1 Application 1

Company 1 Application 2

Company 1 Application 3

Company 1 Application 4

Company 2 Application 1

Company 2 Application 2

...

I would have, in PowerBi, something like :

+ Company 1

+ Company 2

+ Company 3

...

And when I click on the "+" button I would have all the related applications belonging to each company. I am pretty sure that there is a way to do this. I have searched on the forum, on the internet, but found nothing like this.

In brief, I just want to regroup all the applications by company in my final view. The relation is working well.

Can you help me, please ?

Many thanks,

Jonathan 

[SpartaBI · Accepted solution]

@Quenjo just create a matrix visual and put the relevant column in the rows (it has the + feature turned on by default):

In case it answered your question, please accept it as a solution to help the other members find it more quickly. Appreciate Your Kudos 💪
Showcase Report – Contoso By SpartaBI 
Website Linkedin Facebook 
This is SpartaBI!

[Quenjo]

Dear SpartaBI,

I really couldn't expect a better solution. Definitely give you some Kudos 🙂 

Many thanks,

Jonathan

[SpartaBI]

@Quenjo haha my pleasure.

But you need to actually click on the like button to actually give the Kudos 😆

[Quenjo]

@SpartaBI ahaha sorry I am new to PowerBi. By the way, this tool is really amazing. 

[SpartaBI]

@Quenjo no worries 😄 and yes, this tool is the best there is in its market 💪