Forum Discussion
Solved
Sort column not exposed in Transform data
Have a column measure that is not exposed in Transform, is there and FORMAT command I can use in this to make sure it sorts correctly, tried other suggustions using Tooltips but those do not work. T...
The MonthDayNumberYear measure or column.
Tried this however returned some strange results, slicer not returning correct dates..?
The MonthDayNumberYear measure or column.
Got this working, forgot to add "Year" in the data item, so now it sorts correctly, thank you.
BratKat
No, just keep the original YearMonth column in the x-axis and use the "sort by column" option to sort the YearMonth column by the YearMonth column number. Go the table view, select the YearMonth column then from the "sort by column" option, select the YearMonthNumberAlready did that, its usually when I move the Slicer that it stops sorting correcty, using the "between" option in the slicer.