Forum Discussion

jcabrera's avatar
jcabrera
Regular Visitor
1 year ago

No data elements on matrix

Hi, 

I have a problem with non-data elements in my matrix or table. I want to display the specific value in each row but as there are no values in some rows, it automatically puts the average in each row instead of the specific value and it doesn't give me the option to ‘show elements without data’ in the ‘Matrix’ visual object.

 

 

How can I do it for showing the real data in each row, leaving it blank in rows that have no value. 

Need Help
Tips and Tricks

8 Replies

  • MFelix's avatar
    MFelix
    Super User
    1 year ago

    Hi jcabrera ,

     

    If you are selecting the value from a column on your data just select the option Don't summarize that should give you all the results you need.

  • jcabrera's avatar
    jcabrera
    Regular Visitor
    1 year ago

    Well, this doesn't work, it appears like an error if I do what you said as if it did not find the origin of the data as there are empty spaces for some rows

    • MFelix's avatar
      MFelix
      Super User
      1 year ago

      How do you have the visualization setup? Is it possible to send up a sample?

      • jcabrera's avatar
        jcabrera
        Regular Visitor
        1 year ago

        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.

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi jcabrera ,

    Thanks for MFelix's reply!

    And jcabrera, the information you have provided is so minimal that it is almost impossible to know what your problem is based on that information alone. May I ask you if this is a column in a data table or a measure or calculated column created with DAX?


    The reason for this problem is usually a structural problem with your data, could you please provide us with your data so that we can better understand your problem?

    Best Regards,
    Dino Tao