cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dan849800 Frequent Visitor
Frequent Visitor

Hierarchical Slicer Issue

 

 

 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

graph2.PNG

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

 

 

 

 

 

6 REPLIES 6
Super User
Super User

Re: Hierarchical Slicer Issue

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Dan849800 Frequent Visitor
Frequent Visitor

Re: Hierarchical Slicer Issue

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

Re: Hierarchical Slicer Issue

chart.png

 

Mfelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Dan849800 Frequent Visitor
Frequent Visitor

Re: Hierarchical Slicer Issue

image_upload.png

 

Please see above image and let me know Smiley Sad

Super User
Super User

Re: Hierarchical Slicer Issue

How is your hierarchy made?

Please tell me the type.of.fields.

MFelix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Dan849800 Frequent Visitor
Frequent Visitor

Re: Hierarchical Slicer Issue

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.

 

DATA.PNG

 

 

GR_1.PNG