Forum Discussion

kpavan999's avatar
kpavan999
Frequent Visitor
5 years ago

X-axis Chart with 2 dimensions

Dear experts,

 

I would like to achieve something like below. Where striked off is 1 dimension and FY22 Q21 is year dimension.

If i use drill down, i dont get this instead ill get FY22 Q21-striked1,FY22 Q1-striked2.... etc

 

 

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    kpavan999 Seems like you could build an adhoc hierarchy in your Axis field well and then use the forked arrow icon to drilldown. Can't be certain though. You may have to turn off "concatenate labels" in the X-Axis properties settings.

    • kpavan999's avatar
      kpavan999
      Frequent Visitor

       , Thank you for your response.
      I tried that, but no luck(turning off "concatenate labels" didnt work for some reason)