Forum Discussion
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 does not calulate properly due to (i think) the heirarchy seen below. I have alredy turned off the automatic hierachy settings, this has not resolved the issue. What else can i do?
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
10 Replies
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
Hi! ABonx
When you are using the date field please ensure you are turning off the hierarcy from data viz pane. See ss below.
By default it would be selected as hierachy, once you select that you will see the other output shared below.If this is not what you are looking for please share more details and a sample output maybe in excel what exactly you are looking for, this will help in understanding your problem.
Hello, the bar graph moves in line with the date filter on the left hand side of my report. I have included a screen grab below
Hi! ABonx
You might have to share a sample pbix file and expected solution and I'll be happy to guide you further. When you say" Hello, the bar graph moves in line with the date filter on the left hand side of my report" what is the expectation here? The date filter will change your graph, in case you don't want that you can turn of the interactions.
Please be clear with your ask.
Hello Akash_Varuna
I still cant resolve this. I have dragged the data i am using into a matrix column so you can see the issue. The sum of calls per day is not adding correctly when using the filters on the right side. The sum of calls per day and visit count come from two different data sets and i have used dates as their relationship. If i remove dates from the relationship connection and use manager name instead i still get the same issue
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 SrikanthHi ABonx
I wanted to follow up since I haven't heard from you in a while. Have you had a chance to provide the sample data so that i can have a check and provide the solution.
However, if you're still facing challenges, feel free to share the details, and we'll be happy to assist you further.
Looking forward to your response!
Best Regards,
Community Support Team _ C Srikanth.Hi ABonx
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to provide the sample data or pbix file.
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!Best Regards,
Community Support Team _ C Srikanth.
