Sorting Quarters and years formula

[jazzista]

Hello.. Is there a way to sort years and quarters per below. When I bring the slicer to sort my tables: I want the order like 2016 Qt1 2016 QT2 2016 QT 3 2016 QT 4 2017 2017 QT 1 2017 QT 2 etc etc? Thanks in advance
[TABLE="width: 128"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent, align: right"]1
[/TD]
[TD="width: 64, bgcolor: transparent"]2016 Qt -1
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[TD="bgcolor: transparent"]2016 Qt -2
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3
[/TD]
[TD="bgcolor: transparent"]2016 Qt -3
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]4
[/TD]
[TD="bgcolor: transparent"]2016 Qt -4
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]5
[/TD]
[TD="bgcolor: transparent"]2017 Qt -1
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6
[/TD]
[TD="bgcolor: transparent"]2017 Qt -2
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7
[/TD]
[TD="bgcolor: transparent"]2017 Qt -3
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[TD="bgcolor: transparent"]2017 Qt -4
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9
[/TD]
[TD="bgcolor: transparent"]2018 Qt -1
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10
[/TD]
[TD="bgcolor: transparent"]2018 Qt -2
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11
[/TD]
[TD="bgcolor: transparent"]2018 Qt -3
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]12
[/TD]
[TD="bgcolor: transparent"]2018 Qt -4
[/TD]
[/TR]
</tbody>[/TABLE]

 

[mole999]

if you have a real the date it should sort. I've not used slicers on text

 

[jazzista]

Hi Mole999: This is a date table inside powerpivot so they are real dates: When I sort the quarters by quarter number , it groups all quarters together: QT1-2016 QT-1 2017 QT1 2018 etc. I want to know if it is possible to sort the quarters so that it shows the quarters in the correct order on a slicer
. I would like to sort it something like this so it shows in the slicer in this order

2016- 1 Qt
2016 - 2 Qt
2016 - 3 qt
2016- 4 qt
2017- 1 qt
2017 -2 qt
2017 -3 qt
etc etc

Thanks in avance