Forum Discussion

Lemi's avatar
Lemi
Frequent Visitor
1 year ago

Xviz Gant Chart

Hello , I am using Xviz Gant Chart Free version.  I have a projects,departments,customers, issue's of those projects and etc. I have several Levels of hierarchy in My Task  Name (6 levels). Thats w...
Need Help
Show and Tell
Tips and Tricks
rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
1 year ago

Hi Lemi - It is due to how Power BI handles hierarchy levels and the aggregation of data for visualizations. When you select only one level of the hierarchy, Power BI doesn’t automatically summarize the dates for that level because it lacks the higher-level context provided by additional levels.

Replace the date column in your visualization with these measures. This approach ensures that the visualization correctly shows the range of dates for the selected level.

Check the relationships between your tables to ensure they are set up to allow filtering across the hierarchy levels correctly.

Ref Links:

Date Hierarchy in Power BI: Ultimate Guide for Users

Power BI - Dynamic Hierarchies