BI Viewer - Bar Chart Order by Time Dimension

MCoit
New Contributor

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!

1 ACCEPTED SOLUTION

matt515
New Contributor III

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.

View solution in original post

2 REPLIES 2

matt515
New Contributor III

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
New Contributor

Thank you so much!  That did it!