The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

MCoit's avatar
MCoit
New Contributor
2 years ago
Solved

BI Viewer - Bar Chart Order by Time Dimension

Hello,

I'm trying to create a 5 quarter bar chart trend in BI Viewer, but I can't get the time dimension to properly display the columns in the correct time order, it keeps defaulting to alphabetical (ie Q4 2022, Q3 2022, Q2 2023, Q2 2022, Q1 2023).  Does anyone know how to fix or adjust for this?

Thank you!

BI Viewer
  • matt515's avatar
    matt515
    2 years ago

    Are you using a cube view MD data adapter? If so, set Add Start End Calendar Time to True.

    Then use these two new fields: EndDate/StartDate in the BI Viewer graph. This will enable more options for you to use such as Month-Year, Quarter-Year, etc when you select how you want to display.

2 Replies

  • matt515's avatar
    matt515
    New Contributor III
    2 years ago

    Are you using a cube view MD data adapter? If so, set Add Start End Calendar Time to True.

    Then use these two new fields: EndDate/StartDate in the BI Viewer graph. This will enable more options for you to use such as Month-Year, Quarter-Year, etc when you select how you want to display.

    • MCoit's avatar
      MCoit
      New Contributor
      2 years ago

      Thank you so much!  That did it!