Date values on columns header depended from what's expanded/collapsed on matrix rows

[lukasz_r128]

In a pivot table on rows, I have a kind of hierarchy. Row data can be expanded or collapsed. On the other hand, the column headings contain the dates in terms of year> quarter> work week.
Is it possible for the column values to change in the column headings depending on what is expanded in the rows at the moment?

Example:

Right now I have data only for level 1 where values are 1, 2, 3 and workweeks are 18'22, 25'22, 26'22 and at this point it's perfect.

Here I'm expanding my data from Level 1 to Level 2.

The desired effect is to change the workweeks value from those assigned to the values from Level 1 (a, b, c) to those assigned to the values from Level 2 (d, e, f), i.e. 18'22 to 20'22, 25'22 to 26'22 and 26'22 to 36'22

Is that possible? - if yes how to achieve that.

[lukasz_r128]

@lbendlin Thank you for your answer. I wasn't aware about hierarchies on columns. However I'm pretty sure that's will be to difficult for my users to use this. I was able to solve it in a different way with measure and ISFILTERED and SWITCH function. 

[v-eqin-msft]

Hi @lukasz_r128 ,

Could you tell me if @lbendlin 's post helps you a little? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.Hope to hear from you‌‌

Best Regards,
Eyelyn Qin

[lbendlin · Accepted solution]

You can have field hierarchies on rows and on columns.  It is not automatic though, you will have to teach your users how to click on the arrows and fork ("duo-dent"?) and how to change the drilldown between rows and columns.