Forum Discussion
Sort Months o
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
a) In the date or transaction table, create a calculated column, say as "DisplayMonthSort", and values for July as 1, Aug as 2, ... June as 12
Idea is same as fiscal month display.
b) In the model, hide this column in the report view i.e., using "Hide in report view"
c) In the model, select the month column, and click on sort by column and use the "DisplayMonthSort"
d) Create visualizations will give the same effect.
If you already have visualizations, it should automatically apply the changes. If not, save, close and open.
🙂
Sample screens to give an idea
dummy data:
hide in report view:
sort by column:
duumy data visualization:
Thanks for your resposne., how to create transaction table?
What I meant is in your data table AKA transaction table. You can create a column and hide it.
DisplayMonthSort = var _m = Month('Table'[DateCol]) var _startMonth = 7 -- July return If( _m >= _startMonth, _m - 6, _m + 6)
If your table is huge, then you can do the same behavior in the date table and link to it and use the date table's month.