cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Quenjo
Helper II
Helper II

How to display all the lines of a Matrix

Hi community,

 

Let me explain my issue with some example :

 

First of all, look at my table schema :

 

tables.png

 

In a few words, we have companies, which have servers and these servers are containing one or more databases.

 

My goal, is to do a Matrix with three main line :

 

+ Company

    + Servers

         + Databases

 

2022-06-10 09_12_34-facturation_ge - Power BI Desktop.png

 

company_serv.png

 

Here is an example with a company (with the expanded tab) which contains a bunch of servers. Everything works here.

 

The problem is that I have a bunch of servers, some containing a database and some not. When trying to expand a server, it does not show just an empty line if the server does not contain a database. When I click on a server to expand it, it will bold out all the servers and I can click only on those who are containing a database.

 

Like this :

 

serv_db.png

 

On my new list, I have only the servers containing a database. However, I do not want this. I just want a list with all the servers and when expanding it, it just shows an empty line if a server does not contain a database and the database name if the server contains a database.

 

Hope that you understand my needs. Let me know.

 

Best regards,

quenjo

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Hi @Quenjo ,

What you want is the below?

vluwangmsft_0-1655113978046.png

 

Could you pls  share a sample data you have.Remember to remove confidential data.

 

 

Best Regards

Lucien

Hello @v-luwang-msft ,

 

Yes, what I want to have is like in your example. 

 

Let me do an example with sample data :

 

Company table :

Id : 000f65bf85c075009df60450c7656e7f

Company name : This is my company

 

Server table :

Id : 3b14da5d1b30309015a540498b4bcb45

Server Name : This is my server name

CompanyId : 000f65bf85c075009df60450c7656e7f

 

Database table :

Id : 4a1d82eedb57f7009a11681b06961959

Database name : A database name

ServerId : 3b14da5d1b30309015a540498b4bcb45

 

Now, every database is on a server, although a server could NOT have a database.

 

However, in my Matrix, when I click on the "+" button of the servers, it exapands the matrix only by showing the servers which have a database :

 

Quenjo_1-1655120892740.png

 

 

Like in my first example. Hope you understand what I want to achieve.

 

Best regards,

Jonathan

 

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors