Forum Discussion

HerdedByDorpers's avatar
HerdedByDorpers
Regular Visitor
4 years ago
Solved

Slicer not functioning for directly related fact table

Hi All   Thank you for your attention to this question, I appreciate your time. I am new to PowerBI.   Overall Context: I have a data table which holds the IDs of various 'WBS' codes, each of whi...
Need Help
  • HotChilli's avatar
    HotChilli
    4 years ago

    The WBS table cannot filter the Budgets table because the relationship is inactive (that's hard to see in the model diagram due to the scale but the line is dotted).

    Powerbi won't let the relationship be active because there would then be 2 paths between WBS and Actual By Month tables.

    There are ways around this but it's really telling you that the model doesn't work.

    ---

    I'm not sure what visuals and measures you want to explore in your data so I can't say "Here's the model you need" but there does seem to be a duplication of fields in different tables and I don't like the many to many relationship that's there.

    --

    Have a think about what you want in your visuals, simplify the model and go again is my advice. 

HerdedByDorpers's avatar
HerdedByDorpers
Regular Visitor
4 years ago

Thank you HotChilli 
I had to make a few changes to address the issues and make it fully operational.

  1. I removed the problematic many-many relationship to the date table.
  2. I removed other conflicting relationships and made sure that they were cascading 1:Many relationships.
  3. I reestablsihed the original 1:Many relationships and made them active.
  4. I set up a proper date table
  5. To link date tables to my monthly data I needed an extra field which had the first date of each month so that the link would be 1:Many.