Forum Discussion

MCoit's avatar
MCoit
New Contributor
2 years ago

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 alphabetica...
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.

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!