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