2) When i drill down data to next level --(go to next level in the heirarchy) (data shown is 2017 but x-axis shows as 2000,2050. i was not quite sure where it is coming from, I have created H...
I have done in unpivot and data looks like below and slicer is created based on Dails_Hours column and column used in x-axis is DH and Year heirarchy, please see below and let me know if any questions.
