Forum Discussion
Issue with Calculating Project Progress Percentage in Hierarchical Structure in Power BI
My main issue in Power BI is that when I click the plus sign in the matrix table to expand the hierarchy and view its sub-levels, the value in the column for the main level disappears, showing only the values for the sub-levels. This is the default hierarchical display behavior in Power BI, where the parent level’s value hides once you expand its children, making it challenging to view both the main level and its sub-levels simultaneously.
My goal is to ensure that even when I expand the hierarchy, the value for the main level remains visible in the table, allowing for better comparisons and a more comprehensive view of the data.
HI Naserkordian,
Please turn on "Row subtotals"
My main issue in Power BI is that when I click the plus sign in the matrix table to expand the hierarchy and view its sub-levels, the value in the column for the main level disappears, showing only the values for the sub-levels. This is the default hierarchical display behavior in Power BI, where the parent level’s value hides once you expand its children, making it challenging to view both the main level and its sub-levels simultaneously.
My goal is to ensure that even when I expand the hierarchy, the value for the main level remains visible in the table, allowing for better comparisons and a more comprehensive view of the data.
HI Naserkordian,
Please turn on "Row subtotals"