Forum Discussion
Matrix dynamic expansion
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 o...
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