Forum Discussion
No data elements on matrix
How do you have the visualization setup? Is it possible to send up a sample?
I will put some more photos. As you can see, I have all of my data according to a flock. In the first columns I have data for all my flocks son I have no problem. The problem comes in the last column, where I only have data in three or four of my flocks, it is like the Power BI recognise the empty spaces and only put in every row the average data of the four only rows that I have with information because is unable to leave empty spaces in the column.
So I tried to select the option "Show items without data" but it didn't appear. (In the photo it is in spanish, the translate it's "Mostrar elementos sin datos" and it doesnt appear.
An then I tried to do what you said putting "Dont summarize" but as you can see in the previous image, it doesn't appear too in matrix visualitation; but if I select the same data in a table it appears correctly but this happen.
So these are my data:
Thank you very much.
Hi jcabrera ,
Since the value is part of your matrix, on the flock (Lote) select the "Show values with no data" that should return the values that you need.
Ok, I have done it, but nothing change...
Hi jcabrera ,
Without any data just by the images is difficult to pin point what can be happening. in the column you higligth you want to have the average values or the values of each of the %?
This is related with the way you want to present you data vs the values that you have, for a single row of that matrix do you have more than one value?