Forum Discussion
Date hierarchy
Hi ABonx
Could you please share the sample data or pbix file if there is no sensitive information.
I will try my best to resolve your issue. Else do share your requirement in detail so that I am happy to assist you on your issue.
Best Regards,
Cheri Srikanth
Hi ABonx Could you check for these please
- Check Data Type: Ensure the Dates column is set as "Date" in the Modeling tab.
- Disable Date Hierarchy: Use the Dates column directly in the chart instead of its hierarchy (Year/Quarter/Month).
- Check Relationships: Ensure both datasets are properly related on the Dates column in the Model view.
- Use Calendar Table: Create a calendar table with DAX if needed:
CalendarTable = CALENDAR(MIN(Table[Dates]), MAX(Table[Dates]))
- Aggregate Values: Ensure the values are aggregated in the chart.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
Hi Akash_Varuna
I have checked the above. All is ok and correct accept I have not created a date relationship and when do try and create the relationship between dates i get this error message
Hi ABonx The error occurs because Power BI enforces a single, clear filtering path between tables. If there are multiple paths (direct or indirect) that connect two tables, it creates ambiguity about how filters should propagate
To address this you can delete one of the existing indirect relationships or ou can delete one of the existing indirect relationships.If possible, merge tables or create a single fact table
