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.