Hierarchical Slicer Issue

[Dan849800]

 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 Hierarchy based on Year/Month Name/Date

3) When i click on show next level, colors in bar is missing, it is considering as default color,please help me out  thanks

[MFelix]

Hi @Dan849800,

In the options of the x-axis change the type from continuous to c ategorical and you will get the 2017.

Regards,

Mfelix

[Dan849800]

i dont have option to change,im using 2.40version,can you pls let me know which version are you using it

[MFelix]

Mfelix

[Dan849800]

Please see above image and let me know 😞

[MFelix]

How is your hierarchy made?

Please tell me the type.of.fields.

MFelix

[Dan849800]

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.