Forum Discussion

PWRBI_USER's avatar
PWRBI_USER
Frequent Visitor
4 years ago
Solved

Regarding snowflaked dimension

Hello,

  I have a snowflaked dimension which is linked as below. I did the "1 to many" from A to B and from "B to Fact".

                A---*B---*Fact

I have couple of slicers in my report. Now when I pull a column from snowflaked dimension ("A") into the report, it is showing alll the rows(Cartesian). Ideally as per the slicer, it should show only one value from the dimension.

    Is there any reason for this? Or is it like PBI cannot handle snowflake directly like this?

 

  PS: If I merge tables A& B, and pull the column from merged data, that works correctly and as expected.

 

 

Thanks,

 

10 Replies