Forum Discussion
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 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?
2 Replies
- rajendraongole1
Super User
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
rohit1991To 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]))))
Table 1: Products related to the selected Location. Table 2: Products not related to the selected Location.
