Forum Discussion

rpiboy_1's avatar
rpiboy_1
Icon for Helper V rankHelper V
3 years ago

blanks in slicer, after validating data integrity

I've watched the GiaC video on this topic, as well as reading a few blog posts and forum posts.

 

I've validated my data, there are not any scenarios between my Fact table and its Dimensions that would result in a 'blank' row being inserted into my Dimension tables. If my Fact table is a dimension to another Fact table, would that cause a blank in a slicer?

 

I have not gone as far as attempting to use this tool, perhaps that is the next step I should take? I've dealt with this before, and typically inserting my own 'unknown' row via Power Query to clean up the integrity of my data.

 

I should note I'm building the dimension and fact tables from mostly flattened JSON data, and I'm also implementing my own FK/PK in Power Query due to the fact that I'm gettting data from multiple data sources, so I have to generate 'global' unique keys.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi rpiboy_1 ,

     

    //If my Fact table is a dimension to another Fact table, would that cause a blank in a slicer?

    Please make sure that the multiple side do not contain null values and that each value can be found on one side.

     

    When the model is complex, I also recommend that you use some similar tool to test the validity of the relationship. These are not intuitive in the PowerQuery Editor.

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum