09-21-2023 02:12 PM
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!
Solved! Go to Solution.
09-21-2023 04:27 PM
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.
09-21-2023 04:27 PM
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.
09-21-2023 04:31 PM
Thank you so much! That did it!