Skip to main content
M
MCoit
September 21, 2023
Solved

BI Viewer - Bar Chart Order by Time Dimension

  • September 21, 2023
  • 1 reply
  • 0 views

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!

Best answer by matt515

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.

1 reply

M
matt515Answer
September 21, 2023

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.

M
MCoitAuthor
September 21, 2023

Thank you so much!  That did it!

Terms & ConditionsAccessibility statement