Hi. I had this query in another post threat but I reckon it's actually a different post threat sorry if that's the case. Attached is the current date hierarchy levels order.
Basically, the level hierarchy doesn't appear correctly in the visual graph when I drill it up/down. I have tried to concatenate the X dates visual graphs but no joy and only year/month/QRT/dates appear individually, not concatenated.
I believe it's because of the hierarchy order but the point is that I would like to change the order of the hierarchy but it seems this option changed around 2021 and you couldn't drag it anymore Before I was able to change the hierarchy levels order by dragging them up and down. I googled it and the option of dragging the hierarchy levels up and down changed around 2021 and advises to go to the view model instead to drag the hierarchy up and down in there but no joy there either so my guess is that it's changed again since then?
Is there a way to change the hierarchy levels order? It may be not quite working in my visual for one reason or another and maybe it's just a matter of dragging up/down in the end not sure. Thank you for your help
Basically, the level hierarchy doesn't appear correctly in the visual graph when I drill it up/down. I have tried to concatenate the X dates visual graphs but no joy and only year/month/QRT/dates appear individually, not concatenated.
I believe it's because of the hierarchy order but the point is that I would like to change the order of the hierarchy but it seems this option changed around 2021 and you couldn't drag it anymore Before I was able to change the hierarchy levels order by dragging them up and down. I googled it and the option of dragging the hierarchy levels up and down changed around 2021 and advises to go to the view model instead to drag the hierarchy up and down in there but no joy there either so my guess is that it's changed again since then?
Is there a way to change the hierarchy levels order? It may be not quite working in my visual for one reason or another and maybe it's just a matter of dragging up/down in the end not sure. Thank you for your help