Skip to main content
L
LeAnnTDang
Newcomer
September 16, 2022
Solved

BI Viewer - Line chart Order by Time dimension

  • September 16, 2022
  • 1 reply
  • 1 view

Hello,

I am attempting to build a simple line chart through BI Viewer with Cashflow amounts in Y axis and Time (month-year) in X axis. I cannot get it to sort properly so it display data to flow through time. In the X axis, I choose Time for Arguments and sort in ascending. But it sorted as 2021M1, 2021M11, 2021M12, then 2021M2. When I change Time display from Name to Description, it goes by April-2021, April 2021 etc.

How do I set this up so Time dimension flow through chronologically?

Best answer by MichaelSBrokaw

LeAnn:

Try EndDate instead of Time.

Example provided for Month with abbreviated format. Year in Series.

 

MichaelSBrokaw_0-1663346893326.png

 

1 reply

M
MichaelSBrokawAnswer
Newcomer
September 16, 2022

LeAnn:

Try EndDate instead of Time.

Example provided for Month with abbreviated format. Year in Series.

 

MichaelSBrokaw_0-1663346893326.png

 

    L
    LeAnnTDangAuthor
    Newcomer
    September 16, 2022

    Thank you Michael. That did it!

    Terms & ConditionsAccessibility statement