Forum Discussion

MarcoFogale's avatar
MarcoFogale
Advocate I
5 years ago
Solved

relationship create a blank with no reason: data is consistent

I'm studying DAX and I created a simple file. I'm having trouble with a relationship that creates an unexpected extra blank, even though the data is super simple and consistent. This is the dimensio...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  MarcoFogale ,

     

    Yes,when you create relationships,those only have values on one side,the other side will return blank.Just as below:

     

    A workaround for you:

    Select the visual>go to filters pane>choose "advanced filtering">"is not blank",then "apply":

    And you will see:

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

negi007's avatar
negi007
Community Champion
5 years ago

MarcoFogale more oftern or not this is caused by data intergrity issues. There might be some data mismatch which causing blank values to appear in the slicer. It is possible that one side of your relationship table might be having null or blank values.

 

please read this article to have more clarity on this issue

 

https://www.encorebusiness.com/blog/blank-value-in-the-power-bi-slicer-and-filter/#:~:text=In%20actuality%2C%20seeing%20a%20blank,data%20in%20the%20data%20model.&text=The%20reason%20it%20appears%20is,in%20other%20words%3B%20bad%20data.

 

in the meantime, if it possible for you to share your powerbi file so that we can do investigation at our end as well.  I recreated the similar data structure at my end as well and I did not face this blank value issue. 

  • MarcoFogale's avatar
    MarcoFogale
    Advocate I
    5 years ago

    Hello and thank you for your answer.

    How can I share the file? I'm sorry I'm new to the Community and I haven't already figure out how to share files...

     

    It's not a data issue. The strange thing is that if I start a new file, with the very same data source, it works perfectly. I create the relationship, I can even create a new one on another table with the same column from the dimension table, and it works.

     

    But when I try to make it on the file I'm using, it simply can't.

    I have tried to get rid of the ID and use the name instead. It works perfectly with the column name from my dimension table to another table. But when I try to link it to the "Sales", it creates a blank, exactly as you see in the pictures I posted before. So it has the same behavior using an ID column with the whole-number data type or a text column with the same data pattern. 

     

    It really looks like a corrupted file. It's a little scary. I mean, this is only a training file and I don't care a lot about it, but if it happens to an important report and I have to restart it over, that can be a real issue....

     

    Please let me know how I can share it with you.

    Thank you a lot