Show all rows in matrix visual - even when there are no values

[Anonymous]

Hi all,

I am working on a dashboard where it is necessary to display data in the matrix visual. The matrix is planned to look like this:

Products	Year 2019	Year 2020	Year 2021	Year 2022
A) Product 1	0	0	0	0
B) Product 2	e	f	g	h
C) Product 3	i	j	k	l
D) Product 4	m	n	o	p
E) Product 5	0	0	0	0
F) Total	u	v	w	x

Now I have products 1 and 5 which were not part of my portfolio in those years, but are in year 2023 which results in the follwing matrix:

Products	Year 2019	Year 2020	Year 2021	Year 2022
B) Product 2	e	f	g	h
C) Product 3	i	j	k	l
D) Product 4	m	n	o	p
F) Total	u	v	w	x

Is there a way to get my matrix to show all products (like shown in first matrix) even if all the values are "0"?

Thanks in advance 😁

[Anonymous · Accepted solution]

Hi  @Anonymous ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Measure =
IF(
    MAX('Table'[Value]) =BLANK(),"0",MAX('Table'[Value])
    )

2. Result:

Or if you click on the yellow label "Show items with no data", the values that are not displayed will be displayed as Blank()

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[glolge_SLB]

I tried this solution. Its not working when i am showing count for each cell. the Matrix is not showing the Row or column if the data cells are not available. if i show blank rows then its not showing anything but blank rows. How to show all rows and columns even if some cells are blank with count 

[OlTar]

Is there any solution to display not all rows but from lists only? 

[ShinyMinds]

Thank you for your answer, it helped a lot with a similar problem of mine

[Anonymous]

Hi, I have the same problem, but I have several columns with null values. How can I fix that?

Regards,