Forum Discussion

mac_xpert's avatar
mac_xpert
Regular Visitor
9 years ago
Solved

Problems sorting correctly by date

Hi.   I have a Stacked Area Chart that shows financial data starting in May 2017 and running through to April 2018.   I have a column of correctly formatted dates in my query. I've set the data t...
  • parry2k's avatar
    parry2k
    9 years ago

    You have to create your own hierarchary for drill, add Year/<your month field>/Date as part of hierarchary. if need further help , let me know.

  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    mac_xpert

     

    As parry2k said, you need to create a Calendar hierarchy, and drill down to Month level to get your expected result.

     

     

    Regards,

parry2k's avatar
parry2k
Super User
9 years ago

You have to create your own hierarchary for drill, add Year/<your month field>/Date as part of hierarchary. if need further help , let me know.