Forum Discussion
Issue with Power BI Relationship Automatically Changing from One-to-Many to Many-to-One
Dear all, I have tried to create a one-to-many relationship in Power BI, but it keeps changing it to many-to-one. I have made sure to mark the date table as a date table, ensured that b...
Do you duplicate date in the forecast table?
If so this relationship looks fine
i do have duplicates in the forecast table. My point is that i want to set a relationship where first table is date (date column) and forecast (date) as second with relationship ONE TO MANY direction single and it does not allow me and swap it to many to one relationship where table FORECAST takes first and date as second but for graphs i need this relationship to be ONE TO MANY