Forum Discussion
Shabb
4 years agoFrequent Visitor
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...
vanessafvg
Community Champion
4 years agowhere 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