Forum Discussion

ABonx's avatar
ABonx
Regular Visitor
1 year ago
Solved

Date hierarchy

Hello,  I have two data sets in my power both have dates in and number values. I want to create a bar chart that puts the values side by side calulating the totals in line with dates. My bar chart d...
Need Help
  • v-csrikanth's avatar
    v-csrikanth
    1 year ago

    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

ABonx's avatar
ABonx
Regular Visitor
1 year ago

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 

 

Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

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