Xviz Gant Chart

[Lemi]

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 why i have created Parameter  to select 1,2,3,4,5 or 6 Task Names.
When minimum 2 levels  is on, dates are summarised, but when i select only one level it does not summarise my Dates for that one level.
So if i select only department_ name, instead of showing min and max date's of those department it dublicates this task name for each issue and its a mess.
1. If minimum 2 task names are selected it works,

2. but if  Only one is selected, then it does not summaries: 

What can i do?

[rohit1991]

To achieve your desired outcome in Power BI:

Steps:

1. Create Table 1: Use the following DAX formula to return all Products related to the selected Location in the slicer:

Table1 = FILTER(Dataset, Dataset[Location] = SELECTEDVALUE(Dataset[Location]))

2. Create Table 2: Use this DAX formula to return all Products not related to the selected Location:

  Table2 = FILTER(Dataset, NOT(Dataset[Product] IN CALCULATETABLE(VALUES(Dataset[Product]),Dataset[Location] = SELECTEDVALUE(Dataset[Location]))))

Now, your visuals will display:

• Table 1: Products related to the selected Location.
• Table 2: Products not related to the selected Location.

[rajendraongole1]

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