Forum Discussion
Sort Months o
- 4 years ago
I advise and Ashish, others also mentioned the same above. (separate date table concept)
a) Create a table for our needs i.e., simple month table "Month Names"
The table is static and create as using enter data
The table data has always only 12 rows i.e., month names. The names are the same values in the Transaction table. January, February ...
Table: "Month Names"
b) Create "DisplayMonthSort" in the transaction table. Which Ashish is called as Month Order column. Steps are
Create relationship between "Month Names" and your Tx table "Mail V..."
Bring the column "DisplayMonthSort" to your transaction table
DisplayMonthSort = related('Month Names'[Display Month Sort])and do the sort order like we talked above.
Try the other steps like Sort by column, hide in report view ...
See if this works
Note: Sample mockup data .pbix file always helps
Thanks
I am getting error beacuse my date column is using TEXT datatype. I am trying to change datatype but not succesfull yet. any suggestion
Please can you post the screenshot, remove the personal/identifier data
- sdhn4 years agoResponsive Resident
I am trying to create caluclated colum in the existing table.
- sevenhills4 years agoSuper User
The syntax I provided is based on "date" data type column. Since you have text and without knowing full details, let us do this way...
DisplayMonthSort = Switch( 'MailVolumFY1'[FY 2020-21], "July", 1, "Aug", 2, "Sep", 3, "Oct", 4, "Nov", 5, "Dec", 6, "Jan", 7, "Feb", 8, "Mar", 9, "Apr", 10, "May", 11, "Jun", 12 , 1)By default , this column data type will be Whole Number. (verify)
- sdhn4 years agoResponsive Resident
I am able to create calculated column. I hide new column on report view. I click on ... top let of graph but do not see this new calculated column