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 w...
Need Help
SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

PWRBI_USER not sure what you are facing, can you share a sample file?

PWRBI_USER's avatar
PWRBI_USER
Frequent Visitor
4 years ago

 As per the snowflake, with slicer value, it should show only "Mutual Fund". But shows all.

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

    Hey PWRBI_USER already very late in my timezone (22:16 now) so ping me here tomorrow and we'll continue

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

      PWRBI_USER hey, can you do a quick teams/ zoom call now and show me?

      • PWRBI_USER's avatar
        PWRBI_USER
        Frequent Visitor
        4 years ago

        Hi,

          I inboxed you the details; as I saw your message late.  Let me know what time works for you. Alternately I attached  the screen shot of data (in above message)  in 3 tables and how my snowflaked dimension is showing all rows when I filter data using slicer.