Forum Discussion
Quarter table
unnijoy now that you have the column with the format of QTR, number and year that you want. then you have in the X axis.
if you click in the visual you will see 3 points on the top right, click on this, select sort ascending by and here select your X axis and then you will have your x axis sorted like Q1 2020, Q2 2020, Q3 2020, etc
its no giving me in the correct sort order.
unnijoy what are you trying to sort?
i see in your first point that you want to create a table with the quarters. Do you refer to create a table (dataset) with the info or do you refer a visual table (similar to matrix table).
If it is the first option, it is not necessary to have sorted the table becasue you can sort the info in the visual in the format that you want
If it is the second option, you need to add the column Quartername in the table and then you can click in the header of the column visual and the system will sort the info. and if you click again you will sort from z-A. Other option is using the 3 points option of the visual ans sort.
This should work, in any case it doesnt work it would be very helpfull for us if you can paste some screenshots or the bi example in the comments.