Can not Expand While Drilling in Matrix visual
I have a sales volume report in Matrix visualization, as you can see in the attached images, I have 5 level of rows headers. So as default, while I drill up to the top level (Industry), I can expand down to lower levels such as BU, Channel, Category and Product Group without any issues. However, the Management Team when to view from middle level, that mean they drill up to only the Channel level and expand down to Product Group level, so when I drill down to the Channel level, Power BI does not allow use the expand function anymore. Can anyone help me with this issue? Apprieciate your kind support!
Dynamic Date measure for custom tooltip when Drilling up or Expanding
I am creating a custom tooltip for a line chart. Users can Drill up or Expand to the next level in the date hierarchy (Year - Quarter - Month). In the tooltip, I'd like to write a measure to display the Year only when viewing on 'year' level, Year and Quarter only when viewing on 'quarter' level , Year and Quarter and Month name on 'month' level. Or any other alternatives. Currently I'm placing textboxes "Year","Quarter","Month" next to respective card visuals (using SELECTEDVALUE()); but a. it's difficult to align them nicely and b. when you're on the 'year' level, the quarter and month cards are blanks, while the texts "Quarter" & "Month" are still there.
