Forum Discussion

fernandoC's avatar
fernandoC
Helper V
5 years ago

Errors when filtering by Month

Hi,

 

I'm trying to create a visualization that includes 3 different fields: "Location" on the Legend, Sum of Training Hours Delivered and a Month column for the Axis. For some reason, I started received the following error message when trying to create this visual using the "Month" Column: 

 

 

I have the same visuals on another report and they work perfectly (see attached)

 

 

The values on the left visual is coming from a simple sum of values and the second from a calculated column but on this new report none of them seem to work when filtering by Month. 

 

 

I guess is a problem with the relationship between my dates table and my fact table but I cant seem to find where the issue is coming from. 

 

The data model on the left is the one causing issues, the second one is from the other report where it works fine. 

 

 

Any insight would be appreciated.

 

Best, 

Need Help

1 Reply

  • HotChilli's avatar
    HotChilli
    Community Champion
    5 years ago

    I can't give you the detailed reason because I can't see the data or measures but the data model is not a star schema, there are bi-directional relationships and there is a many-to-many relationship, so that's why it's broken.  It looks relational rather than dimensional.

     

    Rework the model so that the dimension tables filter the fact table and sort out the bidirectional relationships.

     

    Good luck