Matrix dynamic expansion

[razieh12]

I've created a matrix within Power BI, with rows designated for months, weeks, and days, showcasing sales data. My goal is to enable expansion solely for the most recent month. From there, I desire only the last week of that month to be expandable, while keeping all other periods unexpanded. Importantly, I'm aiming for this behavior to be dynamic—no matter the updates to data or dates, the expansion setup should remain consistent as I've outlined.

[Martin_D]

Hi @razieh12 ,

You can do this with DAX measures. The "+" signs in front of the week rows will still appear, but no sublevel opens when clicking on it if you don't want to.

You can tweak the basic parent-child hierarchy DAX pattern to achieve this. For ragged hierarchies, preventing to show a sub-level needs to be done in DAX anyway, so you don't need to add a lot to make it dynamic. In the parent-child hierarchy pattern, the behavior of showing or not showing a sub-level is based on the pathlength (depth). But you can also make it based on a certain week or anything else. You just need to return blank for those days that shall not appear.

BR

Martin