Power BI not splitting by groups- pie

[Shabb]

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...."

[vanessafvg]

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]

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

[vanessafvg]

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?

[Anonymous]

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