Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Date Hierarchy Stacked Column Chart- Not Displaying Correctly

Hi,   I am having a simple issue getting a stacked column chart to show the data in the correct chornological order when it comes to months. The data recorded in days, but January should be 2020 bu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

I have tried this but it doesn't seem to work for me?

 

Kind regards

 

Dominic

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi Anonymous ,

Do you create a new column of Month? Please use the new column rather than the date hierarchy. And please share a few screenshots which is using my formula.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks, I managed to resolve this by creating a new column for month and then a new table for ordering and creating a relationship between the two.