Forum Discussion

Aamir2021's avatar
Aamir2021
Advocate I
3 years ago
Solved

Getting Blank in Slicer Visuals

Hi Super Users, I have created a table with the help of Enter Data in Power BI Desktop.  When I apply table visuals then it shows relevant data, however when I turn it into Slicer then it shows one...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  Aamir2021 ,

    Power BI adds an automatic blank row to any table that is connected to another one and there is a relationship between the two, and there are missing keys in the one that is on the one side of the relationship.

    Table1:

    Table2:

    Relationship:

    Table1 is missing data from Table2 and Blank() appears.

    You can leave Blank() next to Filter to not display it.

     

    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.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  Aamir2021 ,

Power BI adds an automatic blank row to any table that is connected to another one and there is a relationship between the two, and there are missing keys in the one that is on the one side of the relationship.

Table1:

Table2:

Relationship:

Table1 is missing data from Table2 and Blank() appears.

You can leave Blank() next to Filter to not display it.

 

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.