Field Parameter - Hierarchy

I tried to replicate but couldn't. I wonder if this has to do with the usage of Auto Date/Time in your model (I always switch that off and use a date table instead). Some other causes could be additional relationships somewhere between these tables which are causing the issue. I'd suggest adding these 3 tables only to your relationship view, and then right click on each table -> "Add related tables". This will allow you to check if you have any "extra" relationships with other tables in the model, which need to be deleted before being able to create the one-to-one relationship. That said, if your output is workign as intended - I wouldn't worry too much about it 🙂 The only difference is you won't be able to invert your hierarchy if you want to use the drill down buttons in your visual.