Forum Discussion

Shabb's avatar
Shabb
Frequent Visitor
4 years ago

Power BI not splitting by groups- pie

Hi, 

 

I don't know why I am having hard time with PowerBI recently 😞

I imported 4 tables one of them is fact (all relationships one to many(Fact)). I am creating a pie: amount by the different categories

* Category column included null at first thought this was the problem, So replaced all nulls for "Unknown" in powerQuery...Unfortunatley the pie still associating all amount to "Unknown" 

* I Also paid attention to the QueryFolding thing so all tables come directly from the DB no "select...."

 

Need Help

4 Replies

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    4 years ago

    where did you replace the value in power query?

     

    this is probably because you have dimensional data in your fact that doesn't have a dimension value in the dimension table.  ie you have an account class in your fact thats not in your dimension table.  pull the dimension value of account class from the fact and see what you get on your visual

     

    ie 

     

    account class from account class

    value from the fact

    and the join key ie the id field for account class in the fact

    • Shabb's avatar
      Shabb
      Frequent Visitor
      4 years ago

      Dear vanessafvg 

       

      My account_class is coming from the dimension not the fact. The measure of amount is coming from the fact .

       

      there is no account_class within the fact table 

       

      Power BI tool going crazy

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Shabb ,

         

        Please check.

        1. There must be no NULL or Blank values in Table 1 (From Column) of the relationship

        2. Every Value in Table 1(From Column) must have corresponding value in Table 2(To Column) of the relationship.

         

        Otherwise Power BI will automatically create a null value to complete the relationship. 

        Power BI is not going to throw you an error if referential integrity is screwed in your data-set, instead you will get inconsistencies in results.

         

        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