Why does my Matrix only displays the lines containing values ?

[Quenjo]

Hi community,

I have the following Matrix schema :

Which works great for the companies, applications and servers, like you can see in the screenshot below :

I have some confidential data, this is why the schema is blurred. What I want you to understand is that here :

A company has one application which has four servers. Now, when expanding each server, I would have a value if a server is containing a database and no values if the server does not contain a database.

However, when I click on the "+" button to expand a server, it automatically goes down in the hierarchy display only the servers which are containing a database :

As you can see on the screenshot above, only two servers contain a database. However, I never want to have this visualisation, all the servers should always been displayed, indipendently of the fact if the have a database or not.

How can I achieve this ?

Many thanks,

Jonathan

[Anonymous · Accepted solution]

Hi @Quenjo,

In fact, this is the basic processing of visual rending and analysis of table records.
They will auto-hide the rows which do not contains values. If you want to force show all rows, please right-click on the category field to turn on the 'show item with no data' option. 

Show items with no data in Power BI - Power BI | Microsoft Docs

If these 'not contain value parts' did not include in your table, you may need to create a parameter table with all category types. Then you can write a measure expression to lookup and aggregate raw value field values and add '+0' after the formula to force expand the calculation on each row.

Regards,

Xiaoxin Sheng

[Quenjo]

@Anonymous ,

This is exactly what I was searching. I really thought using a DAX formula to achieve this even before looking at the simple basic field filters.

"If you want to force show all rows, please right-click on the category field to turn on the 'show item with no data' option. " This part did the job.

Many thanks,

Jonathan