Forum Discussion
Helper IIWhy does my Matrix only displays the lines containing values ?
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
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
2 Replies
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
QuenjoAnonymous ,
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