Forum Discussion

Frequent Visitor

3 years ago

Solved

Dates in the wrong order (Matrix)

hey guys, I have a matrix below that doesnt display the dates in the correct order when the week goes across a month, any ideas how to fix this?:

Greg_Deckler
3 years ago
JamesShawPBI Look at the image you just posted. Look in the upper right corner of the Matrix visualization. See those three dots ( ... ). Those are ellipses. Click them to get a menu of things you can do, one of them is controlling sorting.

Frequent Visitor

3 years ago

Greg_Deckler

Below is the Date Table I am using:

The dates are not in chronological order. I have written the dates in the order they should show up in the image below (in bold):

Greg_Deckler
Community Champion
3 years ago
JamesShawPBI If you use the ellipses for the matrix visualization, what is it sorting on?
- JamesShawPBI
  Frequent Visitor
  3 years ago
  Greg_Deckler
  
  I am not sure what you mean by " ellipses for the matrix visualization, what is it sorting on?"
  - Greg_Deckler
    Community Champion
    3 years ago
    JamesShawPBI Look at the image you just posted. Look in the upper right corner of the Matrix visualization. See those three dots ( ... ). Those are ellipses. Click them to get a menu of things you can do, one of them is controlling sorting.
- JamesShawPBI
  Frequent Visitor
  3 years ago
  ellipses for the matrix visualization, what is it sorting on?
  
  see image below: