Forum Discussion
Power BI Matrix visual- Unexpected Results
I have two datasets with the same Facts/Dimensions and relationships. Dataset A is the original and the only difference between Dataset B is Data A includes additional Facts/Dimensions. Dataset B is a slimmed-down version.
I am trying to recreate a matrix visual on Dataset B and keep running into an issue. The matrix visual has 3 dimensions and 2 fact tables used in it. One of the fact tables ties to all three dimensions and the other fact table ties to two of the dimensions. In the rows area, there is an attribute from the dimension that ties to only one of the fact tables. This will be last in the expanded list.
In Dataset A when I expand to this third layer it shows blanks for the facts from the fact table it is not connected to. In Dataset B when I expand to this third layer it blows out and shows all attributes. This is what I would expect due to no connection to the fact table. When looking at the measures there is nothing special with any of them, they are all just a sum of the value. There is no special filters either.
I am just trying to understand how A is working. Not sure if there is a setting in the table visual or within PBI that is determining this. I thought it would be a measure that is handling this and turning it to blank for Dataset A. That doesn't seem to be the case. Second thought would be a relationship is throwing it off. However, in both datasets the relationships are the same. Double and triple checked. Next thought would be a setting.
Any help would be greatly appreciated. This is a weird thing for me that I have not been able to figure out.