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 c...
Need Help
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

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

    then how are you linking to the account class,, there has to be a key in the fact table that links to the account class otherwise how ar you able to place in on the visual?  otherwise that is why you have a blank value.

     

    fact table ------> key to dimension table  (GL accounts)- what is this dimension key in the fact for the blank account class?  and can you find it in GL accounts?